Help with Filter Query to get data from SharePoint List

(1) Share

Report

Posted on by kriggo15

526

I have a large SharePoint list used for project intake items that I need to get specific data from and am having trouble building the Filter Query.

There are dozens of fields but the ones of importance are:

Created On - date

Project Contact - people picker

Status - 10 different statuses

Follow-up Needed? - Yes/No

Email sent - flag indicating if an email has already been sent (Yes/No, No by default)

The flow will run on the 1st of every month. It needs to grab all items Created greater than 30 days ago, that have a Status that contains the word "Approved" (there are several statuses that have "Approved" in them somewhere), Follow-up Needed? = Yes, and Email Sent = No. For each of those items that match the criteria, an email will be sent to the Project Contact and the Email sent flag will be updated with "Yes".

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Sayan 818 Super User 2025 Season 2 on at

Like (0)

Report

Hii

Please check the below website to get more information about Power Automate OData filter query.

Power Automate OData filter query

Please check this. Hope this will help.

-----------------------------------------------------------------------------------------------------------------------------------------------------

If my suggestion helps you, please gives it a Like and Marks as a Solution. Which motivates to solve more problems.

Thanks,

Sayan Patra

RPA Developer

Was this reply helpful? Yes No
Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

HI,

First Note and this is important. Please immediately have yourself or an admin, create a View in SharePoint that only has the Columns you need. This will be critically important for you if its a large list. And in your Flow, make sure you are using that View as what you query, not the list alone. (and please do not just add columns you want , as that's not the same thing as creating the view which lessons data queried) :-) you'll thank me later lol

Is Status a Choice?

Is Yes/No a Choice? for Follow Up and Email Sent?

People Picker, Allows for Multiple? Allows for Groups?

I don't plan on writing the flow, just the filter as you asked so need to make sure what these columns are.

Was this reply helpful? Yes No