Multiple Person name in HTML Table

[Oelshamy]

I am building a flow for a Tasks reminder to be sent every week, The list is having a person field called Action By and it allows multiple selections, 

I want to show in the HTML Table a column for all the names added in the Action By field 

When i add the Action by field, it returns 

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership| 

Please advise 

[v-yujincui-msft · Accepted solution]

Hi @Oelshamy ,

Here is a link that might help you.

https://tomriha.com/format-multiple-choice-sharepoint-column-in-csv-using-power-automate/

join(xpath(xml(json(concat('{"body":{"value":', item()?['PersonColumn'] , '}}'))), '/body/value/DisplayName/text()'), ', ')

Best Regards,

Charlie Choi

[Oelshamy]

Thank you very much @v-yujincui-msft 

it worked well !! 

[Sheilag04]

Hello, 

I followed the steps and keep getting : 

The template language function 'json' parameter is not valid, the column I am applying the code below is a person/group data type. Any ideas?

join(xpath(xml(json(concat('{"body":{"value":', item()?['PersonColumn'] , '}}'))), '/body/value/DisplayName/text()'), ', ')

[mrgbpjpy]

In that code 

['PersonColumn']

Needs to change to the name of the column of your SharePoint list. For example if you are going to use the Title column then it should be ['Title'] within the code. I hope this helps.