Hi,
I'm currently working in a flow to export a collection from power apps to a worksheet in excel. But when power automate is recieving the collection in json format, it doesn´t recognize as an array but it takes it as a string.
Power automate recieves the json as following:
Solved! Go to Solution.
Looks like there are a couple levels to this, you have JSON inside an array, inside a long string.
try the array or create array expression on the string of the array to get a regular array of JSON strings.
If that doesn’t work, use the replace expression on the starting & ending array brackets & a split on the },{ followed by a join }###{ followed by a split ###
Then if you need to convert the stringified JSON item into regular JSON, use the JSON( ) expression on the string. Then parse in a Parse JSON action.
Looks like there are a couple levels to this, you have JSON inside an array, inside a long string.
try the array or create array expression on the string of the array to get a regular array of JSON strings.
If that doesn’t work, use the replace expression on the starting & ending array brackets & a split on the },{ followed by a join }###{ followed by a split ###
Then if you need to convert the stringified JSON item into regular JSON, use the JSON( ) expression on the string. Then parse in a Parse JSON action.
Hi,
I followed your instructions
But still have a problem with the JSON
Do you have any recommendations or solutions?
Thank you for your time.
What is the Analisis JSON action that is erroring? Do you have a picture of what is in that item?
I edited my answer as I later found the JSON expression can handle a JSON array & not just individual JSON objects.
So the extra Select shouldn’t be necessary, just a regular JSON( ) expression.