web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Using Filter array out...
Power Automate
Unanswered

Using Filter array output in Apply to each

(1) ShareShare
ReportReport
Posted on by 2
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:
I have the same question (0)
  • Suggested answer
    Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at
    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!

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard