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 .
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:
Current flow to read Transaction list 1 and looking up Country manager's list in loop and triggering email :