Answered

Simple Forms to Power Automate - Getting "Expression Evaluation Failed"

(0) Share

Report

Posted on by FreddyD07

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.

Try to complete a simple get Forms responses and send an email based on the individual responses.

Categories:

Using connectors

I have the same question (0)

All responses (8)

Answers (2)

FreddyD07 12 on at

Like (0)

Report
Copy link

Link copied!

Hey All - I think I got it by adding the grouping of questions twice.

Was this reply helpful? Yes No
FreddyD07 12 on at

Like (0)

Report
Copy link

Link copied!

@eric-cheng & @Pstork1 >> Thanks again for the help! The data is pulling in correctly now. I do have one other issue, I have a question that if answered "No" and then one or both of the follow up questions are answered "Yes" it should all be a true statements. However if the first question is answered "No" and both follow up questions are "No" I need the statements to be false (go to the no side).

Any thoughts? Here is a screen shot -

Was this reply helpful? Yes No
Verified answer

Pstork1 68,858 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The trigger for MS Forms doesn't include the answers to the questions. To do that you need to use the Response ID to get the response details. As I mentioned in my original reply that used to require the use of an apply to each loop. It no longer does, but it does require two actions. See the screenshot below for an example.

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @FreddyD07 ,

Can you go to your trigger settings and ensure Split On is set to On.

Then delete and re-add the trigger and Get Response Details action. Refer to the screenshot in my earlier post. No loops required.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
FreddyD07 12 on at

Like (0)

Report
Copy link

Link copied!

Just to add a little more information - I have a 10-ish question Form that I am trying to have PowerAutomate check against the answers (all yes or now with a few add dates in). Based on the Yes/No answers, it emails a particular group. I cannot even get it to check the list of answers that it is pulling. Thanks again for any assistance.

Was this reply helpful? Yes No
FreddyD07 12 on at

Like (0)

Report
Copy link

Link copied!

Here is a screenshot -

Appreciate all the responses and guidance.

Was this reply helpful? Yes No
Pstork1 68,858 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You are probably looking at an old example on the Internet. The trigger for MS Forms originally supplied the forms to the flow as a collection of recently submitted forms. The trigger was later changed to fire for each individual form. So you don't need a for each loop to access the Response ID for the form to get the details. You can access that dynamic content directly.

Was this reply helpful? Yes No
Verified answer

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @FreddyD07 ,

Can you share a screenshot of your flow? You shouldnt need expressions to get the responses from a submitted form.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No