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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / New User - Trying to b...
Power Automate
Unanswered

New User - Trying to build flow that filters excel sheet

(0) ShareShare
ReportReport
Posted on by 4

Hi All - please forgive my lack of knowledge, this is all new to me. I've been spinning my wheels for a while and am looking for a nudge in the right direction. Any input would be greatly appreciated.

What would be the best approach for the following? I'm trying to take an excel sheet / table and return the full row of data if the following criteria is met, 1) Last Name does not equal Smith and 2) One or more of the Gender, Age & Address fields are blank. So in this example, Paul Adams row would be the only row to be returned (and ultimately formatted in HTML table and sent via email).  

I've tried a few different approaches without any luck (likely due to my lack of experience/knowledge of power automate). How would you set this up if you were trying to accomplish the same end goal?

First NameLast NameGenderAgeAddress

Paul

Adams 12 
James

Smith

M 1 Main Street
JamieCollinsF312 Main Street
Categories:
I have the same question (0)
  • ThanksInAdvance Profile Picture
    4 on at

    bump!

  • Verified answer
    v-jefferni Profile Picture
    on at

    Hi @ThanksInAdvance ,

     

    Since you have spaces in those column names, Filter query is not available. So, you need to use Filter array action instead. For the List rows action, you need to open settings and turn on pagination:

    vjefferni_0-1718074204669.png

     

     In Filter array action, apply multiple conditions to get the records you want:

    @and(not(equals(item()?['Last Name'], 'Smith')), or(empty(item()?['Gender']),empty(item()?['Age']),empty(item()?['Address'])))

    vjefferni_1-1718075143147.png

     

    Best regards,

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 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard