I appreciate all help on this issue, I have been struggling with a solution.

I have a column of notes and I’ve updated these notes (via calculated column, in SharePoint) to bring me the concise value that needs to be presented – which is a name.
I then need to reference this value with an excel table which is a roster.

The issue is that the names (via calculated column) are not concise and I need to still locate them through my roster. 
This is a great example of when there is no issues:
SharePoint value – Michael Pignatello
Excel value – Michael Pignatello

When I use this flow design: 

I am outputted a corresponding value from excel, then, from this I will update my SharePoint item.

Example with issues:
SharePoint value: Linda L. Brooks
Excel value: Linda Brooks

I am being brought back no value from excel as it cannot find a match

Please let me know if you have any questions or concerns. Thank you so much for your assistance.

​I appreciate all help on this issue, I have been struggling with a solution. I have a column of notes and I’ve updated these notes (via calculated column, in SharePoint) to bring me the concise value that needs to be presented – which is a name.I then need to reference this value with an excel table which is a roster. The issue is that the names (via calculated column) are not concise and I need to still locate them through my roster. This is a great example of when there is no issues:SharePoint value – Michael PignatelloExcel value – Michael PignatelloWhen I use this flow design: I am outputted a corresponding value from excel, then, from this I will update my SharePoint item.Example with issues:SharePoint value: Linda L. BrooksExcel value: Linda BrooksI am being brought back no value from excel as it cannot find a matchPlease let me know if you have any questions or concerns. Thank you so much for your assistance.   Read More

​