Structure of Get items Filter Query

(0) Share

Report

Posted on by Phineas

4,941 Super User 2025 Season 1

I have a SharePointList1.

I have 'Get items' in my flow.

I want my Filter Query to only return items that -
Have a Status (the default Title column) of "Active" and a FinalMeetingDate less than (meaning has already passed)
or is equal to today.

Assuming SharePointList1 has a single line text column called 'Status' (the default Title column) and a datetime column called 'FinalMeetingDate' (formatted as 00/00/0000), will the following expression accomplish my goal?

Title eq 'string('Active')' and FinalMeetingDate le 'utcNow('MM/dd/yyyy')

All responses (1)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (0)

Report

Re: Structure of Get items Filter Query

Hi , @Phineas
Your syntax has no issue , you can just test to run your flow to see if there is the correct array return in your flow run history.
And for your Date (Which date type in your SharePoint Lis), you need to check the raw DateFormat return in your Get items action.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang