Answered

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

Like (0) Share

Report

Posted on 7 Jul 2018 06:14:08 by rnagpal

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.

All responses (2)

Answers (1)

rnagpal on 25 Jul 2018 at 05:58:44

Like (0)

Report

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

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.
Verified answer

v-yuazh-msft on 09 Jul 2018 at 07:29:28

Like (0)

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

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: