Nov 08 2021 12:52 PM
My Power Automate works most of the time and sometimes it fails with the following error:
"The execution of template action 'Create_HTML_table_2' failed. The column values could not be evaluated: 'The template language expression 'item()['NextStep']' cannot be evaluated because property 'NextStep' doesn't exist, available properties are '@odata.etag, ItemInternalId, ID, Title... "
However the Property 'NextStep' does exist and works the majority of the time.
Power Automate:
1) Gets SharePoint List Items using filter (last 8 hours)
2) Then I put them into an array and add a property to hold a sequential item number (specific to that filtered subset)
3) Parse the JSON
4) Create HTML Table (this step fails intermittently due to the error stated above)
Any ideas?