Hi,
Today I noticed that all of my scripts are broken. They were working last week and the error message says this issue is new.
Error:
ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body/resourceData/responseId']' is of type 'Integer'. The result must be a valid array.
I have roughly 15 power automate scripts that all contain a variation of the following:
Microsoft (group) form with attachment(s) -> SharePoint List -> ADO
When I initially created my scripts using the Forms to SharePoint Template Record form responses in SharePoint | Power Automate,
the Default was:
Trigger = When a new response is submitted"
and then an "Apply to Each" control, that contained an output of "List of Response notifications Response ID" (which allowed for an array) and "Create Item".
(I used this fantastic tutorial, starting at 6:37 https://www.youtube.com/watch?v=K-hiDOPAG-4&t=617s )
Because the "List of response..." option is no longer available, my scripts fail to add the attachment to SharePoint because it's looking for an array.
What is the work around?
Thanks!
Steph
Template as of Dec 2023 (Forms to SP)
List of Response Notifications Response ID no longer available
Error Message