Using Filter array output in Apply to each

(1) Share

Report

Posted on by Erin D.

Hello!

Beginner to Power Automate here, ty ahead of time for the patience.

I'm trying to use this flow to pull all of the data from google sheets, then use the filter array action to narrow it down to an (array) of 'rows' that have a value matching the input value from power apps. I've read a lot of other threads where the "body" output of the filter array can be used directly in a 'Apply to Each' loop, but i get the following error:

It has the [{}] that makes it look like an array of objects but it thinks its a string? I eventually want to loop through the array to narrow the results more and concat everything into a string to send back to powerapps. Any help / advice is greatly appreciated!

Flow:

Categories:

Process Advisor

Sample Data.csv

Filter Array Outp...

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Nived_Nambiar 18,029 Super User 2025 Season 2 on at

Like (0)

Report

Using Filter array output in Apply to each

Hi

I could see that there is a trailing whitespace in the apply to each part where body dynamic content is placed see below

See by removing and making like below makes it work?

Also if i did not work - try this expression and see whether it works ?

I think it should work by the first step which i have suggested itself

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No