Power Platform Community Forum Thread Details

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

Categories:

General topics

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: