web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Is this a bug in Power Automate Itself? I got "InvalidTemplate Error" because a property that does not exist, but it actually does

Posted on by 84

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 seems to be telling a falsehood.

cryptic.png

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 WMThompson_0-1706049976426.png -- to be honest, I forget) 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.

 

Here it is in the List:

list.PNG

Here it is in the csv file:

excel.PNG

 

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.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

Last 30 days Overall leaderboard