Extract multiple values from List (no "name" field available like shown on other examples)

[Anonymous]

Hi, 

I have tried to look up for other similar posts but I couldnt find an appropriate solution to my issue, this is why I am creating a new post, hoping I can get some support. 

I have a column in my Power BI, extracted from a SharePoint multiple choice column online list, that is composed of list items: 

When I click on the "List" , it show me this: 

The values from the multiple choice column the user has selected and their relevant indexes. 

I want to extract those values (all) and get them in one row. 

I found this formula and I have tried it with a costum column but it gives me only one value relevant to the index: 

= Table.AddColumn(#"Removed Columns1", "Custom", each [Trainings and certifications]{1})

I have tried to apply an array of indexes to get all the values but I couldnt figure out the proper way I suppose, it was showing me an error. 

I would greatly appreciate help on this, 

Thank you very much in advance.

[Greg_Deckler · Accepted solution]

@Anonymous When you click the diverging arrows, select Extract Values instead of Expand to Rows. 

[Anonymous]

@Greg_Deckler  Thank you very much! it's perfect , no need coding - the "diverging arrows" button is pretty amazing ! I didnt even notice it before you have mentioned it , thank you so much! 

[jbwtp]

Hi @Anonymous,

I think you may need to do omething like:

each Text.Combine([Trainings and certifications]) rather then each [Trainings and certifications]{1}

This creates a string of all values separated by comma. Is this what you mean by get them in one row?

Cheers,

John

[Anonymous]

@jbwtp  Yes! that's it, it works. 
I have them all in one row 🙂 however they are not separated with comma... 

It shows me this : 

Any idea on how to include the comma between values?  

[jbwtp]

Sorry, of course this should be 
each Text.Combine([Trainings and certifications], ", ") 

[Anonymous]

@jbwtp  thank you very much! Its great