I have a flow that is intended to read data from a CSV file and then compare that data to a Microsoft List in SharePoint. The error I have is at the very bottom/last step in the flow process and it is cryptic.
It says "InvalidTemplate. Unable to process template language expressions in action 'Update_item' inputs at line '0' and column '0': 'The template language expression 'items('Apply_to_each_2')['Profession ']' cannot be evaluated because property 'Profession ' doesn't exist, available properties are 'Title, DOB, Name, Profession, Profession-2 '. Please see https://aka.ms/logicexpressions for usage details.'."
Allow me to break this down for you. 'Update_item' aka "Update item" is the step or "action" where the error occurs. 'Apply_to_each_2' aka "Apply to each 2" is the loop action (or whatever this icon means ) that encapsulates a few actions, the last of which is ".Update item".
'Profession' is simply the name of a column for a single line of text. It exists in the List as well as in the csv file:
Since the error is in an action that is nested inside another action. The parent action shows the error it encapsulates:
If you can see something I can not see, please tell me. If you need any clarifying questions answered, please ask me. But as far as I can tell the error that states property 'Profession ' doesn't exist is false because the property 'Profession' definitely does exist.
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492