The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a SharePoint list column that looks like this:
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.
Solved! Go to Solution.
Instead of [TCD4]{0}, use Text.Combine([TCD4], ", ") to list all of the items separated by a comma.
Instead of [TCD4]{0}, use Text.Combine([TCD4], ", ") to list all of the items separated by a comma.