You’re offline. This is a read only version of the page.
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')
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
Share
Report
5,331
All responses (
Answers (
