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

(0) Share

Report

Posted on by Harry Stover

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.

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:

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

All responses (7)

Answers (1)

Harry Stover 10 on at

Like (0)

Report

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 28,964 Super User 2024 Season 1 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 5,490 Super User 2024 Season 2 on at

Like (0)

Report

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

Hi,

Please refer below screenshot:
Harry Stover 10 on at

Like (0)

Report

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?

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

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 10 on at

Like (1)

Report

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

Thanks Pradeep.

Will look into these solutions.

Harry
Verified answer

Pradeep Rai 5,490 Super User 2024 Season 2 on at

Like (1)

Report

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:

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