cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pribeiro01
New Member

Error trying to export data from Forms to Excel sheet

Hi, I´m trying to export all the responses obtained from a Form in a Excel sheet and getting this error:


The execution of template action 'Apply to each' failed: the result of the evaluation of 'foreach' expression 'lista de @{triggerOutputs()?['body/value']}' is of type 'String'. The result must be a valid array.


Any ideas ?

Thank you

1 REPLY 1
swathirajan
Helper II
Helper II

Hi,

 

The error message says that a valid array is expected in the expression. Please try to use the array function to return an array then use the array to see if it will work.

 

 

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,865)