I'm trying to set up a scheduled daily flow to check a specific column (date column = MVRDate) in a SP List every day. I'd like the flow to check the entire column to see if the current date is for example, 30 days from the date listed in the date column, if it is, I'd like to send an email to myself. Can someone help me out with the filter query with the "get items" action of the flow?
I've been trying to use the following filter query below but I keep getting errors on it.
MVRDate eq addDays(convertTimeZone(utcNow(), 'UTC', 'Central Standard Time','MM-dd-yyyy'), -30)
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
196
Share
Report
All responses (
Answers (
