You’re offline. This is a read only version of the page.
Announcements
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.
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
Hello Haig,
I don't have created by email as an option in dynamic content.
Kind regards,
Harry
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
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
Hi,
Please refer below screenshot:
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
Thanks Pradeep.
Will look into these solutions.
Harry
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
#1
André Arnaud de Cal...
293,296
Super User 2025 Season 1
#2
Martin Dráb
232,093
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
