Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Reading items from multiple share point lists and and send one email based on Country

(0) ShareShare
ReportReport
Posted on by 75

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 : 

 

Sivaperumal31_0-1678285621363.png

 

Sivaperumal31_1-1678285659776.png

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard