Skip to main content

Notifications

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard