I am trying to split the string "Hello | World" into an array words and then return the second result, which should be World.
I know how to split a string, but it's getting the result that I am struggling with.
Split("Hello | World", " |").Result
The above code will do the splittng and return a Table with two rows. I can get the Hello into a variable by using the First() function, but how can I get row X i.e. GetRow(MyTable, 2). Is there such a function?
Also, I know I can use Last() in this scenerio, but for instances where there are more than 2 results I would need a better solution.
Solved! Go to Solution.
Guys, i have a field which i have retrieved through an API named instanceData.
I am getting this field in Dynamics content for further usage but the value that it has is something like this--
i just need this VMNAME value for my further process in the flow, so can i use this split function for this somehow? thanks in advance!
You needs to parse the JSON payload: https://powerusers.microsoft.com/t5/Building-Flows/Parse-JSON-output/td-p/55347
Hi @dcullen, appreciate the prompt response. I have already user Parse JSON action. Have attached the screenshot of it. Please let me know if i am missing something here. Just a beginner!