Flow to send email based on column date (reached today)

[Anonymous]

Hi,

I have a sharepoint list that has a 'Review Date' column (Review_x0020_Date), that i am trying to set up a flow to send an email when that date is reached.

I have tried many options, but it either fails or sends an email everyday even when nothing is in the list.

Any help would be appreciated.

[annajhaveri]

@Anonymous  format the date as shown in below screenshot, in your filter query

[Anonymous]

hi,

I have changed the format, but still getting this error:

[annajhaveri]

@Anonymous Is Review Date a calculated column, if yes then calculated columns are not support in Filter Query 

[Anonymous]

thanks, i did not know that. How would i be able to set this up using a calculated column?

[Anonymous]

i am now using the 'created' column list, the flow runs, but the filter query still does not seem right.

I now want to send an email 90 days after the 'created' date, can you advise the easiest way to do this?

[annajhaveri]

@Anonymous , your filter query looks correct. Just pasting the correct one below if you want to compare your filter query. You are using eq (equals) operation, which will give you items whose Created Date is exactly equals to current date + 90 days, if you are looking for that then use equals, and if you are looking for all items whose created date has passed 90 days then you can use ge (greater than equal) or gt (greater than operator)

Created gt '@{formatDateTime(addDays(utcNow(),90),'yyyy-MM-dd')}'

When you say that your filter query still does not seem right, does it not give you correct results?

[Anonymous]

thanks for the response, i am looking for the email to trigger once the created date passes 90 days.

I am not sure if this is the correct filter or not:

but now getting this error when i put in 'gt':

the filter still seems to be bringing back todays date plus 90 days and not the column 'DateCreated' date.

[annajhaveri]

@Anonymous , you have formatted the date in format 'dd-MM-yyyy' but format needs to be  yyyy-MM-dd, so please change that. 

I am not sure what you mean by " not the column 'DateCreated' date"? Please elaborate.

[Anonymous · Accepted solution]

Hi Anna,

trying to code this myself didn't work, but the send ' birthday message' seems to do what i wanted it to, so have been using this with a few tweaks. Still don't fully understand why creating the above doesn't work.

Thanks anyway

[annajhaveri]

@Anonymous  you are getting error now because Review Date is of type calculated, filter query doesnt support applying filter on calculated column. One alternative of that is to get items using Get Items without filter query, and then use Filter array action to get the filtered items based on review date.