cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cgrimes
Advocate I
Advocate I

Creating a flow that retrieves multiple email addresses and send an email to each.

I have two lists, one is a registry and the other is a category control list. When a new item is created, it is evaluated as go/no go based on the inputs. Each item is required to use a value from the category control list. This link is a general category title. The category control list has a column with a group of people that need to be notified when a project is a "go".  

 

I cannot seem to create a flow that will collect the emails addresses of each of these people and submit an email to them.

 

right now, they are all in one column, with multiple accounts selected. would it be better to have each in separate columns? Each person has a different role.

 

Can someone tell me how to do this? I want to be able to control the contact list separately. I would like an Office 365 (2016) solution.

1 ACCEPTED SOLUTION

Accepted Solutions

I was able to do it by having the look-up column bring with it the ID of the othe list being used.

 

image.png

 

I then used a "Compose"action to pull the Id #

 

@Int(triggerBody()?['Product_x0020_Specific_x0020_Min#Id'])

 

with the ID number as an Int,  I was able to use "Get Item" to pull the relivent emails from the catagory list.

 

image.png

View solution in original post

4 REPLIES 4
v-monli-msft
Community Support
Community Support

Hi @cgrimes,

 

Did you mean that each item of this list has multiple email address in one column? If this is the situation, then I'm afraid that this cannot be done so far in flow. If I misunderstood your issue, please feel free to reply and tell.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cgrimes
Advocate I
Advocate I

Yes, but I can change that.

How do I get the lookup to work for just one? I want one list to find the right email in another list depending on the category selected in the current item.

Hi @cgrimes,

 

It seems that Flow cannot get the data of another column using the lookup relationship between SharePoint lists.

 

Capture.PNG

 

The only dynamic contents I could get are all the columns from List_Test.

 

You could post this idea in the Flow Ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

 

Regards,

Mona

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

I was able to do it by having the look-up column bring with it the ID of the othe list being used.

 

image.png

 

I then used a "Compose"action to pull the Id #

 

@Int(triggerBody()?['Product_x0020_Specific_x0020_Min#Id'])

 

with the ID number as an Int,  I was able to use "Get Item" to pull the relivent emails from the catagory list.

 

image.png

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,049)