You’re offline. This is a read only version of the page.
112
I have a SharePoint list of Contracts that have an Expiration Date column on them.
The Expiration Date is formatted as this: 11/10/2022.
In a flow I would like to use the SharePoint "Get Items" action to filter by only Contracts that have an Expiration Date of 30 days or less from the current date. Could I get some help on what the filter query syntax would be for this type of expression?
The idea is I ultimately want to have this flow scheduled to run every day and email me a list of Contracts that are 30 days or less from today from expiration.
Thank you
Hey @greddin
You can use the addDays function here.
So your filter query should look something like this:
ExpirationDate ge addDays(utcNow(),-30,'Format of your choice('MM-dd-yyyy'))
Not sure exactly this will work, but you can try similar things. Changing the ge to le, and -30 to 30.
Share
Report
All responses (
Answers (
