Showing results for 
Search instead for 
Did you mean: 
New Member

Sending automatic email to distribution list based on a value in a second SharePoint list

I have two lists.  One is a simple pick list with Products and DistributionList.  


The other list is a tracking list for issues from my production plant.  When someone enters a new issue in this list, they select the product from the drop down.  In the Product pick list, I have the email distribution list for each product.  


As part of my "send email upon new issue entry" flow, I want to go find the email distribution list associated with that product selection.  I've tried assigning variables, getting data, etc but can;t figure it out.  I'm new to flows but not new to SharePoint.   Any help is appreciated. 




Community Support
Community Support

Could you please share a sample for those two lists?


We could take use of the OData or the filter array action to get the wanted item, see the following thread for more details:

Obtaining a filtered SharePoint list based off a column


Then take use of WorkFlow Definition Language to get the first record:





Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks.  Makes sense.  


Here's my current flow.  I got the filter array to work.  Easy enough.  But how do I isolate the single record after the array?  My Product list (accidentally named Unit Operation) are unique values.  The flow above has an email to show me the values extracted.  Thanks for your help!

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,895)