Intermittent error on 'create html table' from array

Copper Contributor

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?

 

1 Reply