cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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.

 

Capture1iw.PNG

 

90 days.PNG90 days1.PNG

90 days5.PNG

90dayss.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

10 REPLIES 10
annajhaveri
Community Champion
Community Champion

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

 

annajhaveri_0-1610037314119.png

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.
Anonymous
Not applicable

hi,

 

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

90 days1234.PNG

12.PNG

123.PNG

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

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.
Anonymous
Not applicable

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

Anonymous
Not applicable

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?

 

90 daynew1.PNG90 daysnew.PNG

@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?

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.
Anonymous
Not applicable

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':

 

Capture12.PNGCapture121.PNG

 

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

@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.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.
Anonymous
Not applicable

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

@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.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,769)