web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating a flow that r...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by 55

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.

Categories:
I have the same question (0)
  • v-monli-msft Profile Picture
    Microsoft Employee on at

    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

  • cgrimes Profile Picture
    55 on at
    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.
  • v-monli-msft Profile Picture
    Microsoft Employee on at

    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

  • Verified answer
    cgrimes Profile Picture
    55 on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 796

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 538

Last 30 days Overall leaderboard