couldnt add Group / person email address in content

[Priyan1]

Hi ,

I need an the list of email/display name of persons ( Column "Part mail ad") to be displayed in the HTML to text , but unfortunately "Apply for each" shows error when i try to create a HTML table and input in HTML to text. Also i couldnt find Output of HTML table in HTML to text. 

can anyone help identify whats the problem here,

[Priyan1]

The HTML table was added like this , i tried with compose output still shows error at flow like below

[Priyan1]

@Rhiassuring @vivekpande18  can you tell me the mistake here or short solution for the above problem?

[vivekpande18]

Hi @Priyan1 ,

Is column Part mail ad is single or multi value person field ?

Above column is fetching from Trigger action or Get Items action ?

Thanks

Vivek pande

[ashyriverflow]

hi @Priyan1 I think you don't need to put "Create HTML table" step inside Apply to each. The action itself already acts on an array - in this case it's "Part mail ad" in the From box.

Just move the step outside of the loop will help.

[Priyan1]

It is single value person ( i hope you mean only person Display name visisble when we search=correct me if i wrong and tell me where to look that is single value or multi value) .  And the flow like first "When an item created" > "Get item" action then the steps. 

[Priyan1]

When it ried as you said the below error comes,

[ashyriverflow]

the dynamic contents have been messed up. In the From, it should point to the Part mail ad dynamic content and in the value box, it points to one of the properties within Part mail add.

You can go to one of the run histories and check the actual output of Get item action. You can see the returned values of Part mail add. From there, you can use item('property_name') expression in the value box of Create html table.

[vivekpande18 · Accepted solution]

Hi @Priyan1 ,

To check the single/multi value person field.

1- Go to List Setting

2- Open the Column and check below

Looking at your flow, it seems like its a multi-value field.

Find the steps below to create a table of the names.

1 - After Get Item action, you can add below step

In my case people picker field name is Person. I want name & Email, so i have taken both from dynamic content shown below

2- Add Create HTML Table action and provide output from above action.

 

3 - Use Compose action to format the table

Inputs : replace(body('Create_HTML_table'),'<table>','<table style="width:100%;border-collapse: collapse" border=" 1px solid black">')

You will get the above red highlighted body from dynamic content like below

Note : You need to manually prepare the above expression in text editor.

4 - Pass the above action output directly in email

Output:

Thanks

Vivek Pande

If this post helps answer your question, please "Accept as Solution" to help others find it more quickly.

If you thought this post was helpful, please give it a Thumbs Up.

Subscribe to my YouTube channel to get more interesting content on Power Automate.