To get the list of Display Names I would use XML and XPath. This will allow us to not require a loop making it much more efficient and cleaner.
In my example I've got a list with two multi-select columns. One of type Person (Members) and one of type Choice (Countries).
Below is the full flow. I'll go into each of the actions.
Get items returns all the items from my list.
XML is a Compose action that converts our JSON output from Get items into a valid XML document. We use concat to wrap the output into a root element to ensure it's valid XML. The expression we use here is:
xml(json(concat('{"root": ', outputs('Get_items')?['body'], '}')))
Next, we can build up our table of data using a Select. It takes in value from Get items.
The two expressions to get the list of Members and Countries are below. They build up an XPath expression using the ID from the current item, then wrapped in a join expression to join each member/country with ", ".
For the Members we want to get the DisplayName since it's a Person field. And Countries is a Choice field, so we want Value. You would just need to change the Person field to use the name of your field.
join(xpath(outputs('XML'), concat('//value[ID=', item()?['ID'], ']/Members/DisplayName/text()')), ', ')
join(xpath(outputs('XML'), concat('//value[ID=', item()?['ID'], ']/Countries/Value/text()')), ', ')
This will give us the following JSON.
[
{
"Title": "Team 01",
"Members": "Adele Vance, Lee Gu, Megan Bowen",
"Countries": "USA, Canada"
},
{
"Title": "Team 02",
"Members": "Diego Siciliani, Patti Fernandez",
"Countries": "China, Australia, England"
},
{
"Title": "Team 03",
"Members": "Adele Vance, Patti Fernandez",
"Countries": "USA"
},
{
"Title": "Test 04",
"Members": "Joni Sherman, Johanna Lorenz",
"Countries": "USA, Canada, China, England"
},
{
"Title": "Test 05",
"Members": "Johanna Lorenz, Joni Sherman",
"Countries": "China, Australia"
},
{
"Title": "Test 06",
"Members": "Johanna Lorenz, Diego Siciliani",
"Countries": "Canada, England"
},
{
"Title": "Test 07",
"Members": "Joni Sherman, Nestor Wilke",
"Countries": "England, USA"
},
{
"Title": "Test 08",
"Members": "Johanna Lorenz, Lee Gu, Lynne Robbins",
"Countries": "USA, Canada, China"
},
{
"Title": "Test 09",
"Members": "Lynne Robbins, Nestor Wilke",
"Countries": "USA, Canada, Australia, England"
}
]
We can then use the output from our Select for Create HTML table as so.
And the output of our HTML table is:
