Hi, Am tring to bulid a reminder flow that sends only one email 3 months befor the Renewal (Date coloumn in a sharepoint list). the issue i have is that i get 3 months befor today date, Not from the Renewal field in sharepoint list. How can i sort it out?
this is the formula i used:
Hi @theebalkaseem ,
Please take a try with @RobElliott 's solution, also please take a try with expression below in your flow:
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
When I do this on a daily recurrence trigger I don't use a filter query on the SharePoint list but add some Compose controls:
one for today's date utcNow('yyyy-MM-dd')
I then add a condition that if the output of the today compose control equals the output of the reminder compose control then send the email.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
I assume that the expression you are referring to is the filter query in Get items.
I am also assuming that Renewal is a date/time column that is configure just for the date - not date and time.
Is Renewal a calculated column? If so, you can't use it in an OData filter.
Try the following expression:
Renewal eq 'addDays(utcNow(),-90,'yyyy-MM-dd')'
If this does not work, please post a screen shot of the error message.
Share
Report
All responses (
Answers (
10,153