Forum Discussion
bryanfrumkin47
Apr 24, 2024Copper Contributor
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