Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ninos-shiba
Resolver I
Resolver I

How to expand a SharePoint list column with no expand icon available?

I have a SharePoint list column that looks like this:

ninosshiba_0-1633636380556.png

I don't see the expand arrows to be able to expand. I added a column using the formula below:

= Table.AddColumn(#"Trimmed Text1", "TCD4 Extract", each try [TCD4]{0} otherwise null)

But that only returns the first list item for each row. How do I get all items, maybe separated by commas, for each record? I want all list items, not just the first one.

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

Instead of [TCD4]{0}, use Text.Combine([TCD4], ", ") to list all of the items separated by a comma.

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

Instead of [TCD4]{0}, use Text.Combine([TCD4], ", ") to list all of the items separated by a comma.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.