Email reminder on calculated field

(0) Share

Report

Posted on by Carly100393

I'm trying to create a email reminder from a calculated date field to send when it's 14 days before expiration.

I'm very new to power automate , so would appreciate some guidance.

The out of the box flow that you can select on a date field works fine, but this doesn't work on the calculated field.

Can anyone give me step by step on what I'll need to create.

Many thanks in advance

Screenshot_2021-04-10-13-20-00-074_com.mi.globalbrowser.jpg

Screenshot_2021-04-10-13-21-43-026_com.mi.globalbrowser.jpg

Categories:

Process Advisor

All responses (3)

Answers (0)

CFernandes 8,295 Most Valuable Professional on at

Like (0)

Report

Re: Email reminder on calculated field

Hey Mate, @Carly100393

Can you please review the link - https://powerusers.microsoft.com/t5/Building-Flows/Flow-reminder-from-a-SharePoint-List-Calculated-Field-Date-not/m-p/396501

In the past I have used - do until look to send email reminder, I will try to dig up the Power Automate, solution and share the screenshot with you.
Carly100393 5 on at

Like (0)

Report

Re: Email reminder on calculated field

IM not entirely sure this will work

I need the email alert to tell me 30 days before the Retest is due so am a bit confused how the delay will help at all.

If not i am happy for the flow to send an email 5 months after the date of test

thanks
CFernandes 8,295 Most Valuable Professional on at

Like (0)

Report

Re: Email reminder on calculated field

Hey @Carly100393 ,

The easiest this would be to use the "Delay action" in Power Automate and Pause the Flow for 10 days.

For details see - https://d365demystified.com/2020/06/17/pause-a-flow-using-delay-and-delay-until-power-automate/

It should also be possible to get the calculated values in Power Automate - Just add a compose action and add the field.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!