I have a flow that fails on the Create HTML Table step consistently whenever any change is made to the flow. The basic layout of my flow is as follows.
Trigger every hour -> Get items from Sharepoint list -> Filter array -> Create HTML table from filtered items -> Send email with HTML table in body.
The problem is that whenever any change is made to this flow - changing the name of the flow, adding an email address to the 'Send email step,' or rewording the body of the email, for example - the flow will fail on the next run at the Create HTML table step. The error will read:
'The execution of template action 'Create_Table' failed. The column values could not be evaluated: 'The template language expression 'item()['Column']' cannot be evaluated because property 'Column' doesn't exist, available properties are 'Other columns'. Please see https://aka.ms/logicexpressions for usage details.'
The Sharepoint list these items are in contains 300 items, and no changes have been made to the columns in it since it was created months ago, before these flows were created. The only solution I have been able to find is to delete all Dynamic Content from the Create HTML table step and reenter it, then the flow will run fine until the next minor change. This cannot be done when other small changes to the flow are made; the changes must be saved, the flow exited from then reentered, and then the HTML tables recreated.
Is there a reason these flows keep failing, and is there a solution I can use? It is very tedious and time consuming - I am currently spending more time editing and fixing this flow than I would spend on the emails before we used Sharepoint - but emailed tables are necessary to my work's function and use of Sharepoint. I have several similar flows, some with half a dozen HTML tables, and all share the same problem. Thank you for your help.
Thank you for the suggestions. All the columns in the list are mentioned in the error message, and no changes have been made to them. I have one flow that contains an HTML table made from the contents of a Filter action that does not reaquire remaking with every change, and that flow also draws from the same list. The connection has been reset and reconfigured recently and no change occured - the flow still failed with every change. I have also saved this flow as multiple different copies to make other flows, and all have the same issue. Is there anything else I can try?