Answered

Issues using variables when building flows

(0) Share

Report

Posted on by Jcourtney1485

Good morning team,

I am having a problem tying to use variables when building my flow. For some reason it worked on a previous flow build but now its not. For some reason it keeps failing. Here is the error that its throwing:

"The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array."

Categories:

General topics

All responses (4)

Answers (1)

Sort by

VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!
Before "Apply to each 2" create a Compose action and place there

item()

Show the result.
v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jcourtney1485 ,

I guess you directly select the members Email option directly from the dynamic content, and then flow automatically adds Apply to each 2 action for you. Using items('Apply_to_each') under apply to each will return the information of the current row and its data The type is object and cannot be used in apply to each 2 action. If you just want to output the email address in your multi-select person column as a string, in order to avoid automatically adding apply to each, you need to write the formula item()?['Email'].

Best Regards,
Dezhi
Jcourtney1485 73 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-dezhili-msft @Thanks I will try this out.
Verified answer

Jcourtney1485 73 on at

Like
a
(1)

Report
Copy link

Link copied!

@v-dezhili-msft I figured it out. I had to end up changing the out put for both applies to "Value of "outputs ('Get_MSLevelApprovers')?['body/value']. Kind of weird but it works.