Showing results for 
Search instead for 
Did you mean: 
Post Partisan
Post Partisan

To extract values from Record to list

Hi All,

I have a report with records as shown below.


Please suggest on how to extract this and convert into a list


My requirement is to create list for each customer.

Please help.

Thanks in Advance,


Community Champion
Community Champion


do you want a table like this?

I used the json text you posted to elaborate.

If you want something different, post (aprt of) the original json text





or like this?





Hi @Rocco_sprmnt21 

My requirement is to show awards,4 & business,3 and so on in one row.


I could do it in a column Merged but requirement is to show merged column in a single row



record to list.pngpuoi allegare i dati da cui parti?

La figura c ui fai riferimento è diversa dal testo json che hai incollato.

Prova a popolare a mano su un foglio excel la tabella di aprtenza e la tabella di arrivo.




Community Champion
Community Champion


do you need, by any chance, the Table.ExpandRecordColumn function?


expanded records column.JPG


Community Champion
Community Champion

To extract values contained in a record into a list, use below formula

= Record.ToList([Field Name])

 Replace Field Name appropriately. Hence, for given example, it would be

Solution Sage
Solution Sage

Not sure what you want. Your second screenshot doesn't show a list; rather it shows an expanded record. And I don't see any customer name or ID that you could use to tie that record to a customer.


Please clarify what you want.


Hi @ronrsnfld ,

My table look like


I need help to turn each sections into ordered list for each ssor_id. 

The seconf screenshot i mentioned earlier is what i am getting when I click on 1st section column.

The section column was initially like below


"secondary_section": {
"awards": 4,
"business": 3,
"chargers": 1,
"climate & environment": 2,
"company town": 1,
"dodgers": 1,
"entertainment & arts": 3,
"food": 1,
"latino life": 4,
"politics": 3,
"rams": 1,
"science": 1,
"sports": 1,
"television": 1,
"world & nation": 9
"section": {
"business": 5,
"california": 19,
"entertainment-arts": 1,
"entertainment-arts:movies": 6,
"entertainment-arts:music": 2,
"lifestyle": 2,
"opinion": 3,
"politics": 5,
"science": 3,
"sports": 2,
"sports:angels": 1,
"sports:dodgers": 6,
"sports:soccer": 1,
"world-nation": 16
"top_section": {
"business": 5,
"california": 19,
"entertainment-arts": 9,
"lifestyle": 2,
"opinion": 3,
"politics": 5,
"science": 3,
"sports": 10,
"world-nation": 16

Now I want the 3 columns "secondary_section","section","top_section" to be shown in list rather than showing like Record.

Helpful resources

June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors