I need to pull information from a sharepoint library that contains a calculated column(Date only) for "Next Review Date". I'm trying to compare that to today's date and if equal, send a reminder email.
The issue is I cannot get the comparison to work. I'm using
@equals(items('Apply_to_each')?['Next Review Date'], utcNow())
I've played with the date formats on my "Next Review Date" column and the utcNow() field and NOTHING is working? Any help is greatly appreciated.
Hello all
Hope you can help please.
I've created a similar Flow and need some help, I need Sharepoint to Send an email to alert -60 days before Next Review Date.
The email comes through with the correct details, but it just comes back with all documents in that field rather than 60 days before.
Can this also be set global over all sites or per folder?
String being used when on advanced: @not(equals(items('Apply_to_each')?['Next_x0020_Review_x0020_Date'], formatDateTime(adddays(utcnow(), -3), 'yyyy-MM-dd')))
Hello, @mosturl!
Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!
Thank you for being an active member of the Flow Community!
-Gabriel
Flow Community Manager
Hi @mosturl,
I have made a test on my side and have created a sharepoint list with a alculated column(Date only) "Next Review Date" as below:
I have created a flow as below:
The expression in the Condition as below:
@equals(formatDateTime(items('Apply_to_each')?['Next_x0020_Review_x0020_Date'], 'yyyy/MM/dd'), formatDateTime(utcNow(), 'yyyy/MM/dd'))
The flow would run successfully as below:
Bset regards,
Alice
Another suggestion is to not pull all the items out of the SharePoint list, but put the filter onto the Get Items call and pass it a ReviewDate eq '2018-08-21' OData filter (Filter Query option)