Forum Discussion

bryanfrumkin47's avatar
bryanfrumkin47
Copper Contributor
Apr 24, 2024

Referencing an excel spreasheet

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.

 

No RepliesBe the first to reply

Resources