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?
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
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/
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
15
Share
Report
All responses (
Answers (
