Get columns from tabular data

[beenherebefore]

I have managed to get my PA script to the point where I have a data structure like this inside a For Each:

[

  "Dough",

  "",

  "John",

  "JohnDough@Bakery.com",

  "AP AGING",

  "Aging Details",

  45099,

  2

]

I am at a loss as to how I can reference the elements in this structure and put them into variables. I need to have all these columns available either in variables or be able to reference them in one action so I can insert them into a SQL Database record. I tried Parse JSON but it is apparently not technically JSON so the Action fails. I also tried Select but I guess  I don't fully Grok the intricacies of that action.

Please enlighten me

Thx

[lbendlin]

PAD or PA Cloud?

[beenherebefore]

Cloud Flow

[lbendlin]

Can you guarantee that there will never be a comma in the data?

[beenherebefore]

There are never any guarantees, but since we (IT) are in control of the data and not the users, it is a reasonable assumption.

If something breaks due to splitting on a comma, we can easily fix the data and the volume (Names of Reports and Pages in our Power Bi Service) is low.

[lbendlin · Accepted solution]

Turns out this is much simpler than I thought. I was first going the monster route of using split() and replace()

split(replace(replace(replace(variables('Variable00'),'[',''),']',''),char(10),''),',')

(the "char"  thing doesn't work)

but then I read that arrays can hold different data types.

[beenherebefore]

Cool. I like straight forward vs some magic Action.

I'll give it a go.

Thx

[beenherebefore]

That worked great. Purists may have quicker or fancier methods, but I like this because the process is laid out plainly and you can easily debug and modify in the future.

I've marked your post as the answer.