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
Solved! Go to 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
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
User | Count |
---|---|
96 | |
40 | |
26 | |
23 | |
16 |
User | Count |
---|---|
129 | |
52 | |
48 | |
36 | |
24 |