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

(0) Share

Report

Posted on by Mielkew27

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

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@Mielkew27 ,

Are you able to expand your actions?

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

Was this reply helpful? Yes No
Mielkew27 31 on at

Like (0)

Report
@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

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

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

json(outputs('Compose_EmailAddressCC'))

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

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
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.

Was this reply helpful? Yes No
Mielkew27 31 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mielkew27 31 on at

Like (0)

Report

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

Was this reply helpful? Yes No