web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / ExpressionEvaluationFa...
Power Automate
Suggested Answer

ExpressionEvaluationFailed

(0) ShareShare
ReportReport
Posted on by
For a few years, I've used Power Automate to take responses from Microsoft Forms and put that data in a variety of different spreadsheets across a few different Teams, depending on the answers given.
 
When I set up a new flow recently, I got the error The execution of template action 'All_Numbers' 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 found one post that suggested moving the get response details outside of the apply to each function, but I'm still getting the same issue (screenshot of after trying that).
 
The flow: 
 
 
The error:
 
 
I know this happened once before for me, and that somehow rebuilding the flow from the ground up resolved it--but I'd like to know why and how to fix it, so I can avoid it in the future.
 
I don't have a programming background, and I keep getting a little lost in the searches I've done so far! Please be patient with me.
 
Thank you!
 
Categories:
I have the same question (0)
  • chiaraalina Profile Picture
    2,425 Super User 2026 Season 1 on at
    HI @BR-22061851-0

    What field are you using in the Excel connector?

    Can you show a screenshot? Do you really need the Apply for each?
  • Suggested answer
    David_MA Profile Picture
    14,956 Super User 2026 Season 1 on at
    Based on your screen shot, I believe the issues is with the design of your workflow. You do not show the configuration of the trigger, so maybe you've figured out something creative that I have not discovered, but for the trigger When a new response is submitted (MS Forms), you would only have one Get response details below it and not have multiple parallel actions. The trigger is pointed to one form, therefore the get response details need to point to the same form as the trigger. 
     
    While it may appear to work since the same IDs get generated for every form since the ID is just incrementing number starting at 1, the questions are most likely not the same. You need to create one workflow to process the responses for each form and not one workflow to process the responses from all of your forms.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard