How do I get my output from an array that looks like this:
[
{"JSON_F52E2B61-18A1-11d1-B105-00805F49916B": "{result: The cat is"},
{"JSON_F52E2B61-18A1-11d1-B105-00805F49916B": " in a box at the fo"},
{"JSON_F52E2B61-18A1-11d1-B105-00805F49916B": "ot of the bed in th"},
{"JSON_F52E2B61-18A1-11d1-B105-00805F49916B": "e boy's bedroom}"}
]
Into a string that looks like this: "{result: The cat is in a box at the food of the bed in the boy's bedroom}"
I've spent a week and a half on this and i can't seem to figure out how to grab all the part of my sql query and concatenate them into a single string that I can parse without having to loop through hundreds of them.
Hey @gyjhfyjdrfhj
You could leverage the parse json connector in power automate and the do an append for the JSON_F52E2B61-18A1-11d1-B105-00805F49916B property as show below