I need help on figuring out this Flow. I have a field called "LastDateJob". I need to send email notification 25 days after the last date job. The trigger is the following steps.
1. When new file is created in Sharepoint list
2. User will enter the "LastDateJob" value. example 4/16/2021
3. I need to send out email message 25 days after this "LastDateJob" saying "Thank you for your service"
Note: I am using "Delay until" function (not sure if this is right function to use)
Please help. don't know how can i achieve this. i tried several expressions but i encounter some errors.
Thanks in advance
The issue with your approach is that a Flow cannot run for more than 30 days. I suspect that you'll want the email to go out more than 30 days after the file is created. A better way would be to use a Recurrence trigger that fires every day. Then, use a Get files - properties only action with a query filter. I will create an example and post here.
See my example below and let me know if you have any questions. The expression that I used is in the comments. Take note of the single quotes around the expression and the date format.
I will try the example you provided. Apply it in my flow. I will let you know if this is successful in my case.
thank you so much for your input.
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.