Share via

display rawtext from power query

휴영 최 1 Reputation point
2022-09-27T03:50:36.717+00:00

{

"participants": [

                   {  

                          "lastName": "test",  

                          "email": "testemail",  

                    },  

                    {  

                          "lastName": "test2",  

                          "email": "testemail2",  

                     }  

           ],  

}

i used this json in excel powerquery,

it shows

participants
List

and i clicked List, it shows

Record
Record

and i clicked Record, it shows data.

i want show rawtext not List

like

participants
{"lastName" : "test", "email" : "testemail"}, {"lastName" : "test2", "email" : "testemail2"}

what can i do?

Community Center | Not monitored
0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.