Total from Second Table

(1) Share

Report

Posted on by Sdhn

Below is my scenario:

Table A is the master table, Table B is transaction table so there is a one to many relationship.

For each Item in Table A multiple activities can be created in Table B - this is working

There is a column in Table B called Amount...i want to get total of all items in this column and display in Total Income Column in Table B

Tried to do this using Power Automate which works but its giving a warning of number of times the flow is getting triggered. Currently the flow is getting triggered on when an item is modified. How can i get it to trigger only when the Amount column in Table B changes?

Or Any better way to do this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Shashank Bhide 946 Moderator on at

Like (1)

Report
Copy link

Link copied!

Flow might be running under a human user context, create an application user and run the power automate under that and see if you still getting the error.

Was this reply helpful? Yes No
Suggested answer

Inogic 1,277 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

If you want your flow to get triggered only when there is any change in Account field then you have to give one condition in the Power automate flow.

In the “Select Columns” just add the logical name of the field on which you want to trigger the flow. Then it will only trigger on change of that particular field.

In the below example – I have a flow which will triggered on change of the “name” field in the Account entity. It will only get triggered when the name field changes.

Thanks!
Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No
Suggested answer

ankit_singhal 618 Moderator on at

Like (2)

Report
Copy link

Link copied!

you can use Roll up field as well. Also, in power automate you can set filter it will trigger on amount change only. you can set the condition in trigger body

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,974 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

The answer is you have to add a Trigger Condition.

In the Trigger Condition you would specify which Column or Columns you want it to trigger for. Then it will not trigger for any other columns.

How to trigger Power Automate flow on specific SharePoint column update (tomriha.com)

Please review that.

Was this reply helpful? Yes No
Suggested answer

Sebastian030 86 on at

Like (0)

Report
Copy link

Link copied!

As the user @ankit_singhal suggested, a roll up column is your easiest way to achieve this.

Roll ups are asynchronus and calculated on a sheduled basis / as soon as a row is saved.

You can find more Informations here:

Create and define calculation or rollup columns in Microsoft Dataverse - Training | Microsoft Learn

Define rollup columns with Power Apps - Power Apps | Microsoft Learn

Was this reply helpful? Yes No