Unanswered

Sharepoint List: Flow Automate Email Triggers with Calculated Fields that are not Modified

(0) Share

Report

Posted on by Community Power Pla...

I have a Sharepoint list that functions as a worklist for a team. I have setup a calculated field titled 'Alerts' that adjusts (via flow automate) and displays if the item/record has been sitting in the worklist for more than 24, 48, and 72 hours.

I would like to create a flow that triggers an email to specific parties when this calculated field updates with these 24/48/72 hour flags, NOT when the flow is modified. Since the Alert field auto updates (every 5 minutes with my recurrence timestamp flow), it is not technically modified. Trying to find the right flow to trigger the email alert.

Any suggestions greatly appreciated.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

In general Power Automate doesn't interact with calculated fields very well. Also, is it a true calculated field, ie the value of the field is calculated by SharePoint, or is it just a field where the value is changed by a flow? If its the later then you could just use the when an item is modified trigger with a trigger condition to only fire when one of the values you are setting is set. The fact that you are modifying the field with a flow should still trigger the modified trigger.

If its a true calculated field your other option is to add the logic to send the email in the flow that you are triggering using recurrence.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

the Alert column is a true calculated field. It is a series of If statements that does a datedif against current time and the date/time the request was received.
I like the idea of doing a recurrence flow. Can you help me understand which are the proper step/actions?

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

You said your alert field adjusted via flow automate so I assumed you were already using a recurrence flow to adjust the calculated field. If you aren't using a recurrence flow for that then how are you adjusting the alert? Calculated fields only update when an item is edited. I guess I need to know more about how you are updating the alert field to provide an answer.

Here's the documentation on building a recurrence flow. Run flows on a schedule - Power Automate | Microsoft Docs

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you for your responses!
The Alert field is a calculated field off of a flow automated field. Below image shows the Alert column.
The [TodayDT] Field is the recurrence flow that consistently updates every 5 minutes in order to automatically keep the Alert column 'to date'
I didn't want to build off of this flow since it updates very regularly and don't want emails to be triggered every 5 minutes. Below is an image of my current recurrence flow.

Best,
JKO

Was this reply helpful? Yes No