OData Filter Query

Like (0) Share

Report

Posted on 29 Aug 2024 01:16:47 by DerrickH

194

Hey all,

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)

Categories:

Process Advisor