I have an issue with the following flow :
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 !