I just started my flow journey and I can't find a solution to my problem.

I have two different opportunity types. In type A I want to display the sum of the Amount field of all the subordinate records of type B. All levels should be taken into account. The challenge I am facing is that I may have three type A opportunities underneath each other and then the type B opportunity with the information about the amount.

My idea was to use Get Records to find all subordinate opportunities of type B (no matter to which level) and then run them through a loop.

I can do the loop for the sum of the childs' amounts, but not the grandchilds'...

This should work with a flow or am I completely on the wrong track.

Thanks for your help!

enter image description here enter image description here

  • why not use roll-up-summary fields to do this automatically (or DLRS)?
    – cropredy
    May 27, 2022 at 1:39
  • The first idea was to use a roll-up, but then I need a field for every level
    – Chris St.
    May 27, 2022 at 8:05


You must log in to answer this question.

Browse other questions tagged .