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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Help with Filter Query
Power Automate
Suggested Answer

Help with Filter Query

(1) ShareShare
ReportReport
Posted on by 12
Hello all, I am following the steps of this video: Automate Emailing Excel Task Reminders with ZERO Coding! (youtube.com)
 
In my excel I have two tasks that need a filing reminder, but they go to the same email address.
 
SELECT
 
Then my Compose action is to consolidate the email
Then Apply to each with the Compose Output
Within Apply to each add Filter Array
Using the body from excels list rows present in table 
I use Email from list rows present in email is equal to current item
 
 
here is what current item looks like:
 
but I am still getting a [] for my output of my filter array please help
 
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,968 Moderator on at
    And you lost me at this video.
     
    1. Share your entire flow
    2. Share your entire data (json)
    3. You said but you didn't share any code or anything to explain what you were trying which gave you only that.
     
    Please share your code for the Filter Array please.
     
    here is what current item looks like:
     
    but I am still getting a [] for my output of my filter array please help
  • abc 123 Profile Picture
    789 Moderator on at
    The Filter Array action just flat out sucks when it comes to useability. The @item([Fieldname]) isn't very intuitive, and the Advanced Filter window is absolute garbage. Use notepad to craft the filter, paste it into the advanced window, and hope.
     
     I don't have any interest in watching the video to figure out where you've derailed, but feel free to post your desired Filter criteria, and I can help you craft it.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 276 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 169

#3
Haque Profile Picture

Haque 154

Last 30 days Overall leaderboard