cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oelshamy
Frequent Visitor

Multiple Person name in HTML Table

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| 

 

Oelshamy_0-1664957435204.png

Oelshamy_1-1664957616475.png


Please advise 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

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()'), ', ')

 

vyujincuimsft_0-1664963108715.png

vyujincuimsft_1-1664963118397.png

 

 

Best Regards,

Charlie Choi

View solution in original post

2 REPLIES 2
v-yujincui-msft
Community Support
Community Support

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()'), ', ')

 

vyujincuimsft_0-1664963108715.png

vyujincuimsft_1-1664963118397.png

 

 

Best Regards,

Charlie Choi

Thank you very much @v-yujincui-msft 

it worked well !! 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,513)