Answered

Creating a HTML table where one column has multiple people

Like (0) Share

Report

Posted on 4 Jun 2024 08:28:33 by jsc123

So I'm trying to create a HTML table pulling from a list. It's a travel planner, so every Friday at 10am, we want to output a table which shows the teams travel for the next week. I have got everything working apart from the attendees, I think the problem is that each line in the list can have multiple individuals included. I.e. Travel Test, starts on 1.6.24 and has Bob, Bill and Neil attending. How can I get all three attendees in the attendees column against travel test?

Help!

Categories:

General Questions

All responses (2)

Answers (1)

jsc123 5 on 04 Jun 2024 at 09:01:34

Like (0)

Report

Re: Creating a HTML table where one column has multiple people

You legend! Cheers chief.
Verified answer

v-yueyun-msft on 04 Jun 2024 at 08:41:24

Like (2)

Report

Re: Creating a HTML table where one column has multiple people

Hi , @jsc123

According to your screenshot , you want to get all the emails from your [Gallagher Re Attendees] columns in your SharePoint List.

For example , if this is my test list(My List Name is "List A List" , My Column Name is "Signers", And the "Signers" is also the internal column name in my SharePoint List):

And this is the result in my Select action.

You can refer to my test flow:

join( xpath( xml(json(concat('{"root":{"item":',item()?['Signers'],'}}'))) , '//DisplayName/text()') , ';')

You need to replace your Interal ColumnName in your side.

For how to find the internal ColumnName you can refer to this blog:
How to find the internal name of list or library columns - SharePoint Stuff

And if you want to show the Email , you can use this expression:
join( xpath( xml(json(concat('{"root":{"item":',item()?['Signers'],'}}'))) , '//Email/text()') , ';')

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang