Reply
SonLeThai
Frequent Visitor
Partially syndicated - Outbound

REMOVE RECORD ON LIST IN POWER EDITOR

Please help me!!!

I have List contain Record like that: {"a", [{a1,a2}, {b1,b2}], "b", [{a1,a2},{d1,d2}], ""}

a
Record
b
Record
""

I want to remove Record on list and return it by text, result:

a
b
How can I do that?
Link file example:
https://drive.google.com/file/d/14Ckb0rFQR0zAnQXQA4ahQvaCQolsFBqg/view?usp=sharing 

1 ACCEPTED SOLUTION

Syndicated - Outbound

Hey @SonLeThai ,

 

make the Json file available as well, this is required because I'm going to clean the record inside Power Query.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

4 REPLIES 4
TomMartens
Super User
Super User

Syndicated - Outbound

Hey @SonLeThai ,

 

please create a pbix that contains sample data, upload the pbix to onedrive, Google Drive, or Dropbox, and share the link.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Syndicated - Outbound

Hey @SonLeThai ,

 

make the Json file available as well, this is required because I'm going to clean the record inside Power Query.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Syndicated - Outbound

tks you!!

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)