Skip to main content

Notifications

Community site session details

Community site session details

Session Id : cJOkBKpGRQDr3KSnkpgKoT
Power Automate - General Discussion
Unanswered

Append Email Address from Excel Table Using Multi Select from MS Form to Filter the Company Name to Get the Email Address of all the Recipient

Like (0) ShareShare
ReportReport
Posted on 19 Mar 2023 06:36:52 by 31

Hi,

I'm wondering how to achieve this scenario in Power Automate where I have a distribution matrix from an excel table tagged all the emails by CompanyName and use the same choices in my multi-select in MS form to automate the distribution of emails marked in the form. 

 

I have managed so far while searching tirelessly on the web how to achieve this but quite confusing for someone who's just starting to learn PowerAutomate.

 

Screenshot#1.JPG

 

I started with the Initialized var to get the value from the previous list row 

 

 

@outputs('List_rows_present_in_a_table')?['body/value']

 

 

then used Compose EmailAddressCC to get the output from MS form of the multi-select field value

 

 

@outputs('Get_response_details')?['body/FORM_ID']

 

 

then used Join EmailAddress with Expression json to join the Compose Output EmailAddressCC

 

 

@JSON(outputs('Compose_EmailAddressCC'))

 

 

The Apply to each is not getting the desired output which should only contain a filtered array of the company

Screenshot#7.JPG

Screenshot#5.JPG

How can I filter the excel table using the Array of CompanyName to get all the email addresses and join them using a semi-colon?

 

Any help is greatly appreciated.

 

Thanks,

Mielkew

 

 

  • Mielkew27 Profile Picture
    31 on 30 Mar 2023 at 05:20:38
    Re: Append Email Address from Excel Table Using Multi Select from MS Form to Filter the Company Name to Get the Email Address of all the Recipient

    @SudeepGhatakNZ do you have the solution? Thank you in advance.

  • Mielkew27 Profile Picture
    31 on 20 Mar 2023 at 09:47:11
    Re: Append Email Address from Excel Table Using Multi Select from MS Form to Filter the Company Name to Get the Email Address of all the Recipient

    @SudeepGhatakNZ yes how can I join email from company C1 and C2 

  • SudeepGhatakNZ Profile Picture
    14,318 Most Valuable Professional on 20 Mar 2023 at 08:58:05
    Re: Append Email Address from Excel Table Using Multi Select from MS Form to Filter the Company Name to Get the Email Address of all the Recipient

    So you have a Master data as shown below

    [

      {

        "Email""sudeep@c1.com",

        "Company""Company1",

        "Code""C1"

      },

      {

        "Email""ghatak@c2.com",

        "Company""Company2",

        "Code""C2"

      },

      {

        "Email""sudeep.ghatak@c3.com",

        "Company""Company3",

        "Code""C3"

      }

    ]

     

    and an array of company code as shown below

    ["C1","C2"]

     

    You want to get emails associated with those codes. Correct?

    Not sure I fully understand your question but I will build a sample and share it with you.

  • Mielkew27 Profile Picture
    31 on 20 Mar 2023 at 05:56:39
    Re: Append Email Address from Excel Table Using Multi Select from MS Form to Filter the Company Name to Get the Email Address of all the Recipient

    @SudeepGhatakNZ yes it does not contain the email I would like to use this output to filter the CompanyName column in my excel table to get all the email addresses under these companies and join them using semi-colon for sending emails as CC.

     

    Step1 I used initialized variable "varEmailAddress" to get all the email addresses in the excel table 

     

    @outputs('List_rows_present_in_a_table')?['body/value']

     

     

    Step 2 use the Select and enter in the From the varEmailAddress, to get only the EmailAddress, CompanyName, CompanyCode

    Mielkew27_0-1679290011496.png

     

    Step 3: I use Compose to get a response from the MS form for the list of the company needed to be CC

    Screenshot#4.JPG

     

    Step 4 : I use Join with the expression to join them 

     

    json(outputs('Compose_EmailAddressCC'))

     

     

    Screenshot#5.JPG

    This is where I'm getting nowhere, I want to filter all the emails only containing the company selected in the multi-select option in the MS Form and join them so I can use it to email them later.

    Appreciate your support in getting this flow to work.

     

    Thanks,

    Mielkew

     

  • SudeepGhatakNZ Profile Picture
    14,318 Most Valuable Professional on 19 Mar 2023 at 20:22:45
    Re: Append Email Address from Excel Table Using Multi Select from MS Form to Filter the Company Name to Get the Email Address of all the Recipient

    @Mielkew27 ,

    Are you able to expand your actions?

    From what I see, the input of your Join EmailAdressCC doesn't have email addresses

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
ankit_singhal Profile Picture

ankit_singhal 7 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 4 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 2 Super User 2025 Season 1

Overall leaderboard
Loading started