Skip to main content
Dynamics 365 general forum
Answered

Power Automate- Trigger Email Send When Record Lifespan>365 days

editSubscribe (0) ShareShare
ReportReport
Posted on by 10

Hello there, 

I'm quite new to using Flows and having an issue. I'm trying to create a flow that will trigger an email send to the Created By and/or Owner of an Opportunity Record. 

I have a calculated field called 'Lifespan' which grows per how many days since it was created. 

pastedimage1674039269197v1.pngpastedimage1674039345574v2.png

I would like the trigger to run when this number reaches 365 days. (I've been testing this with DIFFINMINUTES just to see if it will trigger).

My flow is as below:

pastedimage1674039475178v3.png

It doesn't seem to run at all. Could it be that the email address of the created by isn't pulling through?

Any help would be much appreciated.

Thanks,

Harry

  • Harry Stover Profile Picture
    Harry Stover 10 on at
    RE: Power Automate- Trigger Email Send When Record Lifespan>365 days

    Hello Haig,

    I don't have created by email as an option in dynamic content.

    Kind regards,

    Harry

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,934 Super User on at
    RE: Power Automate- Trigger Email Send When Record Lifespan>365 days

    Hi,

    Add another action in your flow 'Get a row by id'

    Select Entity - System User

    Row Id - created by value from dynamic content

    Now use Email address from above step in your send email action

  • Suggested answer
    Haig Liu Profile Picture
    Haig Liu on at
    RE: Power Automate- Trigger Email Send When Record Lifespan>365 days

    Hi Harry Stover,

    CreatedBy(Value) is not an email address, do you have "Created By Email" dynamic content?

    About Dataverse in power automate:

    https://learn.microsoft.com/en-us/power-automate/dataverse/list-rows

  • Suggested answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,483 Super User on at
    RE: Power Automate- Trigger Email Send When Record Lifespan>365 days

    Hi,

    Please refer below screenshot:
    pastedimage1674044414995v1.png

  • Harry Stover Profile Picture
    Harry Stover 10 on at
    RE: Power Automate- Trigger Email Send When Record Lifespan>365 days

    Hi Pradeep,

    I just read through the links you sent. I'd prefer to run a scheduled flow as you suggested. If the LifeSpan of record is greater than X send the email. Could you give me an idea on how the flow should look?

    - Which dataverse action should be chosen in order to pull the fields, (Status, Lifespan, CreatedOn & CreatedBy)

    - In the compose email section, if I enter CreatedBy(Value) as the dynamics value will that send to their email address?

    pastedimage1674043651732v1.png

    Thanks,

    Harry

    [quote user="Pradeep Rai"]

    Hi,

    Power automate will not trigger on Calculate field as explained in below link:

    Trigger (Work-)Flow on change of Calculated Field 

    pastedimage1674040293997v1.png

    Instead this, you can create schedule Power Automate which will run on daily basis and it will check if LifeSpan of record greater then 5 then send the email.

    One more way we have is you can create new field of to store the Calculated Field Values as described in below link:
    https://www.loganconsulting.com/blog/use-business-rules-to-update-values-from-rollup-fields/#.Wa5T7OuGO00

    [/quote]
  • Suggested answer
    Harry Stover Profile Picture
    Harry Stover 10 on at
    RE: Power Automate- Trigger Email Send When Record Lifespan>365 days

    Thanks Pradeep.

    Will look into these solutions.

    Harry

  • Verified answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,483 Super User on at
    RE: Power Automate- Trigger Email Send When Record Lifespan>365 days

    Hi,

    Power automate will not trigger on Calculate field as explained in below link:

     

    pastedimage1674040293997v1.png

    Instead this, you can create schedule Power Automate which will run on daily basis and it will check if LifeSpan of record greater then 5 then send the email.

    One more way we have is you can create new field of to store the Calculated Field Values as described in below link:
    https://www.loganconsulting.com/blog/use-business-rules-to-update-values-from-rollup-fields/#.Wa5T7OuGO00

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans