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!
Solved! Go to Solution.
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:
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
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:
Thank you, this solved the problem!
Should have thought about asking the community earlier... 😁
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
32 | |
15 | |
14 | |
13 | |
7 |
User | Count |
---|---|
39 | |
22 | |
14 | |
10 | |
7 |