Intermittent error on 'create html table' from array

%3CLINGO-SUB%20id%3D%22lingo-sub-2940907%22%20slang%3D%22en-US%22%3EIntermittent%20error%20on%20'create%20html%20table'%20from%20array%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2940907%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20Power%20Automate%20works%20most%20of%20the%20time%20and%20sometimes%20it%20fails%20with%20the%20following%20error%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%22The%20execution%20of%20template%20action%20'Create_HTML_table_2'%20failed.%20The%20column%20values%20could%20not%20be%20evaluated%3A%20'The%20template%20language%20expression%20'item()%5B'NextStep'%5D'%20cannot%20be%20evaluated%20because%20property%20'NextStep'%20doesn't%20exist%2C%20available%20properties%20are%20'%40odata.etag%2C%20ItemInternalId%2C%20ID%2C%20Title...%20%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20the%20Property%20'NextStep'%20does%20exist%20and%20works%20the%20majority%20of%20the%20time.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EPower%20Automate%3A%3C%2FP%3E%3CP%3E1)%20Gets%20SharePoint%20List%20Items%20using%20filter%20(last%208%20hours)%3C%2FP%3E%3CP%3E2)%20Then%20I%20put%20them%20into%20an%20array%20and%20add%20a%20property%20to%20hold%20a%20sequential%20item%20number%20(specific%20to%20that%20filtered%20subset)%3C%2FP%3E%3CP%3E3)%20Parse%20the%20JSON%3C%2FP%3E%3CP%3E4)%20Create%20HTML%20Table%20(this%20step%20fails%20intermittently%20due%20to%20the%20error%20stated%20above)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2940907%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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