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.
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
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
@SudeepGhatakNZ do you have the solution? Thank you in advance.
@SudeepGhatakNZ yes how can I join email from company C1 and C2
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.
@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
Are you able to expand your actions?
From what I see, the input of your Join EmailAdressCC doesn't have email addresses
ankit_singhal
7
Super User 2025 Season 1
Michael E. Gernaey
4
Super User 2025 Season 1
David_MA
2
Super User 2025 Season 1