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

Like (0) Share

Report

Posted on 14 Feb 2018 23:20:43 by Craig99b

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

All responses (2)

Answers (0)

Craig99b 2 on 19 Feb 2018 at 16:23:50

Like (0)

Report

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

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!
v-micsh-msft on 19 Feb 2018 at 09:49:05

Like (0)

Report

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

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