Power Platform Community Forum Thread Details

Hello,

I have had 2 share point lists ( 1. Transaction List & 2. Country Managers list ) previoulsly.

Transaction List 1 contains details about transactions with Country.

Country Managers List contains the manger's email id for different country.

I had a requirement to read each item from transaction list and looking up country manager list for email ID and trigger email to those country managers with respective list of transactions . I have completed the flow with help from community. ( Flow and previous topic link can be seen below )

Now there is new transaction list introduced in another share point list , Lets call it transaction list 2.

I need to enhance the current flow to read one more transaction list along with existing transaction list and still send one email to country managers . I can simply copy and create another workflow similar to current one - but I do not want to send 2 email for 2 transaction lists as number of transactions list will grow in future - So I want to send one email if given country is part of both transaction lists .

Transaction list 2 also contains Country column, and County Manger's list is applicable for both transactions lists (1 & 2).
There can be cases that given country is listed in only one of the Transaction list, Email should be sent to those country mangers with few columns from corresponding transaction list ( this is already kind of completed with current flow itself )
In some cases, Given country can be listed in both transaction lists , in that case country managers should receive an email alert only once with some column contents from both transaction lists.

I am trying to have parallel branch for second transaction list in below current flow and combine the email at the end.

Else I will have to add loop inside Loop (inside Apply to each) - But it would be bad in terms of performance especially of more transactions lists are introduced.

Any other neat solution?, Kindly advise,.

thanks for your time.

Community page which helped me build the current flow:

https://powerusers.microsoft.com/t5/Building-Flows/How-to-Avoid-multiple-emails-when-share-point-items-created/m-p/2033580#M224678

Current flow to read Transaction list 1 and looking up Country manager's list in loop and triggering email :