Answered

Extracting array values into delimited string in To filed of Outlook email

(0) Share

Report

Posted on by rnagpal Microsoft Employee

Hello,

I've a Azure Kusto query connector that returns the results, one of whose fields in an email alias. I need to concat the email alias and append with @microsoft.com and add it to a Outlook Send an email action in the To field.

Can someone help how to I achieve this?

I added a Select Data Operation to the output of the Kusto query results and mapped the email alias on a property. It rurns a json with teh property name and the value. I'm unable to extract the value for each of those properties and create a semi-colon delimted alias with @microsoft.com and use that in the To filed.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @rnagpal,

Could you please share a screenshot of the configuration of your flow?

Could you please share more details about the results returns returns from the Azure Kusto query connector?

Do you want to get all values of a column and append each with @microsoft.com, then send an email to those email address?

If you want to get all values of a column and append each with @microsoft.com, then send an email to those email address,I have made a test on my side to create a sharepoint list with a single line of text column "EmailName"as below:

And I have created a flow as below:

You could insert the column's dynamic content of the Azure Kusto query in the Compose field.

Note:

The expression in the Compose 2 as below:

concat(outputs('Compose'),'@microsoft.com;')

The flow would run successfully as below to send the email to the users:

Was this reply helpful? Yes No
rnagpal Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-yuazh-msft for your suggestion.

I ended up appending the @microsoft.com to the "alias" property in Apply to each and then using that array variable as an Input to teh COmpose action followed by passing it to teh Join action by providing the ; as the delimiter and using teh output of this in teh To field of Send an email action of Outlook.

Was this reply helpful? Yes No