cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Craig99b
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. 

 

Thanks,

Craig

2 REPLIES 2
v-micsh-msft
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:

https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/

 

Regards,

Michael

 

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.  

 Capture.PNG

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

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,082)