Power Automate

Answered

Odata Filter Query filter by two status

(0) Share

Report

Posted on by shelleyb

193

Hello,

I've created a flow to create a csv file of filtered data. The csv file needs to not contain any thing the status of Inactive OR Service. I thought that the filter query would as following but it doesn't work then thought to add condition which causes the flow to error out. Any assistance would be warmly welcomed 🙂

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

creativeopinion

10,508 Moderator on at

Like (0)

Report

Copy link

Link copied!

@shelleyb It looks like you are using the Get Items action which returns items from a SharePoint list—not a CSV file. Can you confirm if you are looking to return items from a SharePoint list or a CSV file?

In the meantime, you might find this YT Tutorial helpful: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No

shelleyb 193 on at

Like (0)

Report
Copy link

Link copied!

Hi @creativeopinion

The flow creates a CSV file from the SharePoint List, the CSV file needs to not included 'Inactive' or 'Service' in the status column.

Was this reply helpful? Yes No

creativeopinion

10,508 Moderator on at

Like (0)

Report

Copy link

Link copied!

@shelleyb In that case, you need the Get Files (properties only) action.

You will need to use the internal column name of your Status column. Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list. If you aren't sure how to get the Internal Column name, you can refer to this section of one of my YT Tutorials.

Hope this helps!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No

shelleyb 193 on at

Like (0)

Report
Copy link

Link copied!

Hi @creativeopinion

Gentle Reminder the flow is set to Get Items from SharePoint list, filter to exclude 'Inactive' and 'Service' and create CSV file from the outputs. The issue is the filter on the Get Items doesn't appear to be working. The CSV file has ALL data rather than a filtered view of the data.

Was this reply helpful? Yes No

Verified answer

creativeopinion

10,508 Moderator on at

Like (0)

Report

Copy link

Link copied!

@shelleyb Sorry I misread your prev comment. I thought you were referring to the CSV file. How many items do you have in your list? Have you turned on pagination? To troubleshoot your issue, I would recommend clearing out the Limit Columns by View field and turning on Pagination.

Also, try the and operator instead of the or operator.

Here's my SP list I'm using in my demo.

I would also recommend adding a Compose action after the Get Items action to count the number of items returned. The Filter Query should filter out your items where the Status isn't equal to Inactive or Service—the Condition action would be redundant.