Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I am currently struggeling with a column that contains a list of nested records.
I get it only done with a list of records but dont know how to do it with a list of nested records. I am almost trying to find a solution for about a few days...
The JSON structur looks likes this:
RED: List of Records
BLUE: first nested Record
GREEN: second nested Record
I want to extract the email address. I dont know why I dont get this running.
I hope somebody can help me out.
Thanks,
Fabz
EDIT:
I don't know what was wrong with me - but I have found the solution. Once again, the solution was quite simple.
each Text.Combine(List.Transform([Column1.node.subscriptions.edges], each Text.From(_[node][user][email])), ";")
Solved! Go to Solution.
good that you found the solution - yes, it is standard JSON parsing.
good that you found the solution - yes, it is standard JSON parsing.