Split Array

[baxschwepo]

Hi to all, 

as I am somehow desperate in the meantime, I thought there might be someone able to help me...

I am receiving a json object in a flow via HTTP request:

[{"language":"DE","text":"1000,Screws,102-22222,purchase"}]

I want to work with the "text" part and insert the single comma separated values  to a sharepoint list. I am able to extract it via "ParseJson" function to a comma seperated text:

"1000,Screws,102-22222,purchase"

How can I split those values?

With a text function (indexof, substring)?

I tried the split function and received an array:

["1000","Screws","102-22222","purchase"]

Easy to get the last and first one of the array..how to access 2nd and 3rd item of the array...is there an easy way? 

Is something like 

I tried already several hours but couldn't find a good way..so many possibilities...

Any suggestions?

Thank you very much! Appreciate your help!

[RezaDorrani]

Hi @baxschwepo 

Here is a video walkthrough of parsing JSON data using flow expressions.

https://www.youtube.com/watch?v=C52brz28poU&list=PLN-cZRQeAiDVQ-6ZWGr43yyTcpu6mUgrR

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

[ScottShearer · Accepted solution]

@baxschwepo 

You can refer to each element of the array by it's index number - arrays are zero based.  My example below gets the second element:

[baxschwepo]

Thank you, this solved the problem! 
Should have thought about asking the community earlier... 😁