Create HTML table with a multi choice field added to email body - Not working correctly.

[nsmarc]

Hi,

I need to create an HTML table that is added to the body of an email.

I have a field (Brand(s) column) from the table that has multiple choices that are causing an issue. I can extract to data okay however within the body of the email the field is not populated correctly. The field is duplicating the value from the last row of the table for that column only.

In the below example I had 2 rows in my table :  One of the row has Merrell FTW as a brand and the second entry has Saucony Originals. For some reasons, when the HTML table is being created, the Brand(s) column is populated with Saucony Originals for both entries.

I would be really grateful is somebody could point me to the information that is missing to extract the right brand.

Thanks in advance.

[v-mengmli-msft]

Hi @nsmarc ,

This is because you put the 'set variable' under 'apply to each', and the value of the final variable is the value of the last run if you use it outside the 'apply to each'.

There's another way about how to get all the options in multiple choice column when creating an HTML table.

Best regards,

Rimmon

[DJ_Jamba]

Could you remove the variable and the join and add a compose instead with the following formula?

join(body('Select'),',')

Then do a test run without sending an email and let me the know results?

[nsmarc]

Hi,

Thank you so much for getting back to me.

I am a newbie at Power Automate so finding my way around.

How do you get rid of the Apply to each 2 and Current item to reflect what have from your side

Thank you.

[v-mengmli-msft]

Hi @nsmarc ,

Please try move it outside 'apply to each 2' manually.

[nsmarc]

haha haha... This is not working.

Really sorry to ask but can you please tell me the exact steps you did after the Initialize variables step.

I did:

Add an action

Then choose Select

From: I have added Brand(s)

When I add Brand(s) value in the map field this is when I get the Apply to each 2 and Current item. 

[DJ_Jamba]

Do this:

So that you are left with:

Then I'll tell you what to do next

[v-mengmli-msft · Accepted solution]

Hi @nsmarc ,

Are you saying that you can't move 'Select' manually? If yes, I'd recommend you use expressions directly.

Best regards,

Rimmon

[nsmarc]

Hi,

Thank you for your reply. I have tried to replicate the steps. However the flow seems to fail.

The workflow seems to fail.