How can I loop through or parse the following JSON received from JotForm? The question is in the 'name' part of the JSON, and the answer in the 'value'. The question can change with each response received so I can't use the normal expressions or Parse JSON function.
Solved! Go to Solution.
Hi @grovercorner2 ,
I don't know if it is a solution but I want to share it.
So the key is to get the dynamic field name.
I create a simple sample.
Now we can extract the values from the columns with dynamic name.
But if your data is more complex, the expressions will also be more complex.
Best Regards,
Wearsky
Hi @grovercorner2 ,
Unfortunately, power automate can't parse json with dynamic names.
Please make sure that the name of key is unchanged.
Hopefully it makes sense.
Best Regards,
Wearsky
Yes, it makes sense, and I have no idea why a large SAAS provider like Jotform would implement something like this. But sadly there is a 0% chance they will change their API upon my request, and I can't wait for them to release a new version of their API.
Hi @grovercorner2 ,
I don't know if it is a solution but I want to share it.
So the key is to get the dynamic field name.
I create a simple sample.
Now we can extract the values from the columns with dynamic name.
But if your data is more complex, the expressions will also be more complex.
Best Regards,
Wearsky
Thanks. I think this is a step in the right direction. But it doesn't take into account the json has multiple rows. How to isolate the first row to use as input to your steps?