Unanswered

Error message setting up flow - Foreach failed

Like (0) Share

Report

Posted on 30 Nov 2023 18:01:41 by RachelWFH

Hi everyone,

I'm new to Power Automate and my colleague is helping me set up a work flow so that when our staff fills out a form it populates into a spreadsheet, sends a confirmation email, and a calendar reminder.

I'm getting this error: The execution of template action 'Foreach' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body/value']' is of type 'Null'. The result must be a valid array.

The Foreach seems to be the problem. I've tried to completely rebuild the process, but I keep getting the same error.

Categories:

Issue

Question

I have the same question (0)

Summarized by AI

All responses (2)

Answers (0)

MikeBeman 28 on 15 Jan 2024 at 10:56:24

Like (0)

Report

Re: Error message setting up flow - Foreach failed

Hi Rachel, what form is being used to trigger the flow?
Mike

Was this reply helpful? Yes No
MikeBeman 28 on 15 Jan 2024 at 12:38:05

Like (0)

Report

Re: Error message setting up flow - Foreach failed

Hi Rachel, I have just built a test flow in my environment (see below) basing this on a MS Form response and the flow runs successfully. Happy to share with you if you wish?
I created the form, created the excel spreadsheet with matching column headers in a table, mapped the responses to those columns and used that data to populate the email and calendar event.
Thanks
Mike

Form to excel.png

Was this reply helpful? Yes No