I have tables with monthly data, and I need to calculate row-level summations. I also need a column-level summation for all columns.
My columns are:
Project ID | Name | Budget Year | Total Amount | Sum Total | Jan | Feb | ... | Dec
'Total Amount' is a calculated column, but this doesn't provide me with the column-level total, so I have a 'Sum Total' currency column that I populate using a flow that gets triggered every time something gets created or modified.
To ensure I don't run into an infinite loop, I have the below in the Trigger Condition:
@not(equals(triggerBody()?['Total_x0020_Amount'], triggerBody()?['SumTotal']))
Alternatively, I also tried:
@not(equals(triggerOutputs()?['body/Total_x0020_Amount'], triggerOutputs()?['body/SumTotal']))
Neither of these work and my flow keeps firing. Could someone point me in the right direction?
Hi @aliensurfer
What if you try with the following expression? If "SumTotal" is empty, then the flow will trigger; otherwise, the flow will not trigger.
@empty(triggerBody()?['SumTotal'])
Hope this helps.
Kind regards.
Community Support Team - Anthony Amador
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
28 | |
27 | |
20 | |
10 |