I have a field
source on contacts populated automatically by an external Id.
Partnership is a custom object on which I can set another
source field. When this field is set, I want to go through all contacts that already have the same
source and get their Account Ids.
Then I create records in a junction object "Partnership_account" with Account Ids and Partnership Id so I know how many accounts each partnership brought.
My flow is technically working but it often makes more that 101 queries (if there are more than 101 contacts with this source).
I think I can avoid that by removing decision and loop elements and use a mass create instead.
In order to use the mass create element, I think I need to populate a collection variable based on Partnership_account object and populated with :
accountId1, partnershipId1, accountId2, partnershipId1, accountId3, partnershipId1, etc.
Problem is that I can't think about a solution to populate this collection variable... Does anyone has any clue ?
If my case is not clear, I can also add more details.
Have a nice day !