Applying Lines.FromBinary to multiple list items

[cka1ser]

Hi PowerBI community!

Disclaimer: I am a beginner and maybe this question is stupid, but after aproximately a whole work-day of research I am not any further.

I am reading from a Azure Blob Container containing multiple JSONs of the same structure and I want them to be combined into one column (as a preparation for further data mangling). My code sample below works as intended and I can use this output for my futher processing. 

let
    Source = AzureStorage.Blobs("myblobstorage"),
    mycontainer = Source{[Name="mycontainername"]}[Data],
    myjsons = Table.SelectRows(mycontainer, each [Extension] = ".json")[Content],
    inputcols = Lines.FromBinary(myjsons{0}, null, null)
    
in
    inputcols

Results in:

But obviously it is just listing the messages from the selected SINGLE (first) JSON file... myjsons{0}. What do I need to add to have the lines from all the jsons in the list myjsons in inputcols?

Cheers, Christian

[ppm1]

Instead of a creating a list, have you tried keeping it as a table and using the Json.Document function to parse the JSON in a custom column?

Pat

[AlienSx · Accepted solution]

Hello, @cka1ser try this

inputcols = 
 List.Combine(
    List.Transform(
       myjsons, 
       (x) => Lines.FromBinary(x, null, null)
    )
 )

[cka1ser]

Thank you so much. This solved it for me.