power automate error ExpressionEvaluationFailed

[SSIMON]

hello,

I have a Microsoft form an i want to put result in excel in sharepoint site.

i use "when a new response is submitted"

i put form id 

next step is "apply to each"

And error is: 

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 don"t understand why i have problem with this form/flow  because I have other similar flows and they are ok

i tested to copy/paste part of other flows but always this message..

Can you help me please ? If you need more information, don't hesitate to tell me.

thks

[abm · Accepted solution]

Hi @SSIMON 

If you collecting the form submission responses it should be something like this. Not sure why you have the Get Response details in a loop. Try the below.

Thanks

[SSIMON]

i know why a have a loop.

because i put response in excel tab who is in sharepoint website. next step is send email 

[abm]

Hi @SSIMON 

You current mapping in Apply to Each loop you mapped the response id which is not correct. Hence you getting the error.

[SSIMON]

my choices are limited:

[abm]

Hi @SSIMON 

Get response should be outside the loop. Check your email.

Thanks

[SSIMON]

i will try it.

but my others flows  are same that:

[VictorIvanidze]

I'm sorry, but it seems your other flows are just badly designed 😉

Only one "Get response details" action is quite enough.

[SSIMON]

ok perhaps they are badly designed but they work

whend a response >>apply to each [get response detail>office-get profile>convert time zone>add row in table>mail for "hey a new response is here"> mail for "failed to sending mail "new response".

only one "get response" but it's in the loop

And this flow is ok but my new flow, looks like other, dont"' work and i dont understand why.