New User - Trying to build flow that filters excel sheet

(0) Share

Report

Posted on by ThanksInAdvance

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 Name	Last Name	Gender	Age	Address
Paul	Adams		12
James	Smith	M		1 Main Street
Jamie	Collins	F	31	2 Main Street

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

ThanksInAdvance 4 on at

Like (0)

Report
Copy link

Link copied!

bump!

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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:

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'])))

Best regards,

Was this reply helpful? Yes No