Get Items Filter Between Two SharePoint Dates in Columns

(0) Share

Report

Posted on by DLCaterhamSch

394 Super User 2024 Season 1

Dear All,

I need some help with Power Automate Flow. I need to filter query using a Get Items on a SharePoint List Start Date Column and End Date Column all rows which are equal to today.

I'm struggling with this, any help would be appreciated.

Kind Regards

Daniel

All responses (1)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (0)

Report

Re: Get Items Filter Between Two SharePoint Dates in Columns

Hi , @DLCaterhamSch
According to your description, you want to use the Filter Query to filter your Date or DateTime Column in your SharePoint List.
This is my test SharePoint List:
And this is the raw output of the "Get Items" action:
(1)If you want to filter the Date without Time column , like "2023-12-07", you can use this code in your Filter Query:
utcNow('yyyy-MM-dd')

(2)If you want to filter the Date with Time column, like "2023-12-07Txx:xx:xxZ" and ignore the Time just in today , you can use this code in the FIlter Query:
utcNow('yyyy-MM-ddT00:00:00Z')
utcNow('yyyy-MM-ddT23:59:59Z')

And you can also combine your condition with or, and logic function, like this:

And for more information, you can refer to :
Solved: FLOW (Get Items) Filter SharePoint list on Date - Power Platform Community (microsoft.com)

Best Regards,
Yueyun Zhang