Answered

Multiple Filters on List Rows Present in a table - Update/Create SharePoint List

(0) Share

Report

Posted on by abonahoom

Hi Everyone,

I'm stumped and it's most likely that I don't understand filter queries very well. I have a flow that that takes an excel table and updates/creates rows in a SharePoint list. All of this is working correctly. What I would like the flow to do is to

have a filter that looks at Employee column and if the name is for example Mike, James, or Tim to update the list otherwise don't update the list. This seems like it should be very simple, but the filter arrays I've created and conditions I've created either update the list with all of the names or nothing. I've attached screenshots of the working flow.

Please help, thank you!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

v-litu-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @abonahoom,

Could you please share how do you configure the Filter query?

If you want to filter out items that employee name equals to Mike, James, or Tim and employee column is person column, you could use the Get items to get all items, then use Filter array action to filter them out, for example:

@or(equals(item()?['Employee/DisplayName'], 'Mike'),equals(item()?['Employee/DisplayName'], 'James'),equals(item()?['Employee/DisplayName'], 'Tim'))

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
abonahoom 83 on at

Like (0)

Report
Copy link

Link copied!

That's the challenge, I think I'm configuring it wrong because when I use it nothing gets filtered out. I tried adding the filter array that you created and nothing was filtered out. Here are screen shots of my get items and filter array. I tested the flow and it created all of the items in from my spreadsheet, it didn't filter out the employee names. Do I need to also create an additional condition?

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @abonahoom,

The column name in the filter query should be “Employee/DisplayName”, not only the "Employee".

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
abonahoom 83 on at

Like (0)

Report
Copy link

Link copied!

@v-litu-msft I entered the filter query exactly as you have it and it's still pulling everything. Here's a screenshot of how the flow ran. Is it normal for the Outputs to be blank?

I then updated the filter array From field to pull from the sharepoint list I get blank inputs and outputs when the flow runs.

Does the filter array need to be moved under List rows present in a table instead of Get items? I tried moving it under list rows present in a table and the flow didn't run.

Was this reply helpful? Yes No
Verified answer

abonahoom 83 on at

Like (1)

Report
Copy link

Link copied!

I was able to get this work by removing the filter array and adding a condition after List rows present in a table.

Was this reply helpful? Yes No