Answered

Flow error dealing with array's and String variables

(2) Share

Report

Posted on by eenochs

147

I'm working on a flow where i want to extract the location text of an email subject line and compare them against a Array of locations and email addresses. If the location matches it sends an email to the address in the array. I believe my problem is comparing a string against a array and getting the following error.

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose_array')' is of type 'String'. The result must be a valid array.

Here is the flow

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Power Platform 1919 2,217 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @eenochs,
you can refer to this document for your use case : https://www.enjoysharepoint.com/check-if-an-array-contains-value-using-power-automate/

Please give the mentioned solution a try and let me know whether it works for you.
If it solves your issue, feel free to mark this thread as answered.
Please make sure to like the response!
Thanks!
- Hemanth Sai

Was this reply helpful? Yes No
Verified answer

Tomac 4,105 Moderator on at

Like (0)

Report
Copy link

Link copied!

In your Compose Array action, make sure you're not using a stray comma after your last curly bracket } and you close the overall bracket at the end with a ]

These will cause the Compose action to set the output to a String instead of an Array.

For more help than that, we will need to see the full output of the Compose Array action in a completed run.

Was this reply helpful? Yes No
Suggested answer

stampcoin 5,158 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@eenochs Hi,

Your information is not enough.

In the array, it only has Name and Email.

So, in the loop, the condition (I guess), should be

equals(items('Apply_to_each')?['Name'], variables('varBUName'))

or just use item()

equals(item()?['Name'], variables('varBUName'))

Was this reply helpful? Yes No
eenochs 147 on at

Like (1)

Report
Copy link

Link copied!

@Tomac

Thank you that worked, i was able to match them up.

Was this reply helpful? Yes No