Select specific column in HTML table to add into "To" in Send an email action

(0) Share

Report

Posted on by nitisak

162

Hi.

I would like a little help to get column in HTML table action to use it as "To" in Send an email action.

another request can I adjust HTML table like fill with some color or border ?

I have the same question (0)

All responses (7)

Answers (1)

v-jefferni on at

Like (0)

Report

Re: Select specific column in HTML table to add into "To" in Send an email action

Hi @nitisak ,

HTML table is actually string with HTML tags but not a table. You can use Select operator to select specific columns from an array and then use expression join(body('Select')['Email'], ';') to concatenate Email column values with semicolons so the result can be used in To field of Send Email action.

For the second question, you can refer to below thread:

Solved: Conditional color formatting html table column- Po... - Power Platform Community (microsoft.com)

Best regards,

Was this reply helpful? Yes No
nitisak 162 on at

Like (0)

Report

Re: Select specific column in HTML table to add into "To" in Send an email action

Hi @v-jefferni

I have to use an output from Filter array or output from HTML ?

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Re: Select specific column in HTML table to add into "To" in Send an email action

Hi @nitisak ,

Select requires a table as input, so, it should be from Filter array. You can use the table outputs from Select to 1. get email addresses and concatenate, 2. create HTML table and insert in email Body.

Best regards,

Was this reply helpful? Yes No
nitisak 162 on at

Like (0)

Report

Re: Select specific column in HTML table to add into "To" in Send an email action

Hi @v-jefferni

Could you see as below I did not know that I did it correct.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report

Re: Select specific column in HTML table to add into "To" in Send an email action

Hi @nitisak ,

Add another Select operator, use Email dynamic content directly in Text mode:

Best regards,

Was this reply helpful? Yes No
nitisak 162 on at

Like (0)

Report

Re: Select specific column in HTML table to add into "To" in Send an email action

Hi @v-jefferni

Sorry it's my mistake. I would like to send email to email one by one depend on value in excel file.

EX. if Accno 1234 that have 6 records in excel and email = test@gmail.com , Accno 55666767 have 6 records and email = test1@gmail.com I would like automate to gather Accno that and send to Email in same row of Accno.

Now I can gather but stuck on send email action.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Re: Select specific column in HTML table to add into "To" in Send an email action

Hi @nitisak ,

If Accno1234 that have 6 records in excel and email = test@gmail.com , how many emails would you like to send to test@gmail.com , 1 or 6? What if there are 6 records with Accno1234 but 3 to test@gmail.com and 3 to test1@gmail.com ?

Best regards,

Was this reply helpful? Yes No