Email reminder on calculated field

Like (0) Share

Report

Posted on 10 Apr 2021 12:29:22 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

I have the same question (0)

All responses (3)

Answers (0)

CFernandes 8,305 Most Valuable Professional on 10 Apr 2021 at 17:57:48

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.

Was this reply helpful? Yes No
Carly100393 5 on 10 Apr 2021 at 16:42:34

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

Was this reply helpful? Yes No
CFernandes 8,305 Most Valuable Professional on 10 Apr 2021 at 12:58:12

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!

Was this reply helpful? Yes No