Flow to send an email 30 days after a date in a sharepoint list - Filter Query help

(0) Share

Report

Posted on by Boppersnr1

137

I am trying to create a flow that will generate an email 30 days after a date in a sharepoint list.

Date Field in sharepoint list is called: Last Preventative Maintenance Check

I am getting this error when I run the flow:

The expression "Last Preventative Maintenance Check eq addDays(utcNow(),30,‘MM/dd/yyyy’)" is not valid. Creating query failed.
clientRequestId: 34cb54b6-b555-429b-9630-a800c10e22fb
serviceRequestId: 34cb54b6-b555-429b-9630-a800c10e22fb

Here is my flow:

I have also tried to use the column name for the date field in the URL for the sharepoint list:

I have the same question (0)

All responses (4)

Answers (1)

Boppersnr1 137 on at

Like (0)

Report

Re: Flow to send an email 30 days after a date in a sharepoint list - Filter Query help

I'm trying a new method. but having issues with the date format. It is returning a date 01/09/2021 but today is 01/12/2021.
I have it set as utcNow('dd/mm/yyyy) as that's what the SharePoint column looks like.

Was this reply helpful? Yes No
Boppersnr1 137 on at

Like (0)

Report

Re: Flow to send an email 30 days after a date in a sharepoint list - Filter Query help

if I change the expression the date results are not right:

addDays(utcNow('dd/mm/yyyy'),30,'dd/mm/yyyy')
returns
17/00/2021

What am I doing wrong?

Was this reply helpful? Yes No
Boppersnr1 137 on at

Like (0)

Report

Re: Flow to send an email 30 days after a date in a sharepoint list - Filter Query help

Ok, I got somewhere but still not getting the successful result.

I changed the expression to this:
addDays(utcNow(),30,'dd/MM/yyyy') and it is returning the right date. but I am getting the error: String was not recognised as a valid datetime. Any ideas?

Was this reply helpful? Yes No
Verified answer

Boppersnr1 137 on at

Like (0)

Report

Re: Flow to send an email 30 days after a date in a sharepoint list - Filter Query help

Got it.
I needed to change the date format from dd/mm/yyyy to mm/dd/yyyy and it worked.

Was this reply helpful? Yes No