Showing results for 
Search instead for 
Did you mean: 
Kudo Kingpin
Kudo Kingpin

SharePoint Get Items Filtered by Date (Recurrence)

I have 2 SharePoint Lists [Absence Request] and [In/Out Board]

I need a recurrence flow to GET ITEMS from the [Absence Request] filter it, and if the staff is OUT TODAY, update the [In/Out Board]


I can create a flow to update the In/Out Board when a new item is created in the [Absence Request] but if the requested dates are in the future, it will not work. I need a recurrence to check the items in the [Absence Request] if one of the approved dates is today, i want the in/out board updated.




Any other option or ideas how to accomplish this task?


Thank you,

Regular Visitor

Re: SharePoint Get Items Filtered by Date (Recurrence)

I was able to filter records for today by using the following condition:

@equals(substring(item()?['InsertYourColumnName'], 0, 10),utcnow('yyyy-MM-dd'))


Please note that the column name is inside of single quotes.

Also, remember that you'll need to replace spaces in your column names with _x0020_

Scott Shearer, MCT
Kudo Kingpin
Kudo Kingpin

Re: SharePoint Get Items Filtered by Date (Recurrence)

Hi @shearersj

Thanks. I tried but failed to understand where to put the condition.  I tried creating a COMPOSE action after the RECURRENCE using "@substring(item()?['EventDate'], 0, 10)" to get the Start Date  -- did the same with End Date.

Then I plugged both outputs in the Filter Query. 

Got an error message due to the Start Date being null.  Which I'm sure it was because I'm missing something between my RECURRENCE action and COMPOSE. 




Frequent Visitor

Re: SharePoint Get Items Filtered by Date (Recurrence)

Hi there,


Did you ever end up getting this one working? It is exactly what I am looking to achieve.\




Advocate IV
Advocate IV

Re: SharePoint Get Items Filtered by Date (Recurrence)

Hi all


did anyone found a workaroudn or a fix for date time fields in filtering?



Helpful resources


Super User Program Update

Three Super User rank tiers have been launched!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (4,853)