Unanswered

Retrieve information from a nested object

(0) Share

Report

Posted on by DS-12051116-0

Hi all,

I have a power automate flow that is connected to JotForms, via a HTTP request I will receive all answers that a user has submitted and after a compose action I am left with the following output. The main issue here is that the numbers will change when I edit my form, but the "name" will always stay the same!

So to use this answers, and keep using them when I edit my form, I need to extract the "name" and "answer" from this object. I've tried many many things but cannot come to a good solution. Mostly because we cannot loop over an object.

Does anyone have good ideas how I can extract the name, answer pair from this output (regardless of the number in front of it)?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi @DS-12051116-0,

A possible low-code approach would be:

- Get all keys from the JSON retrieved by Jotforms (currently represented by the sequential numbers in your image) and store them into an array

- Loop through this array, and access each individual nested object dynamically.

For example, you have an array of ["1", "2" and "3']. Pass this array as input to an Apply to each and, inside the loop, access the respective nested object with an expression like body('HTTP')[item()], where body('HTTP') is the dynamic content corresponding to your request outputs, and item() is the expression referncing the currently iterated array element.

If this approach makes sense for you, here are some additional content about the strategy discussed above. It can be helpful for you or for other users that find this thread in the future:

- Get keys from a JSON object in Power Automate: https://digitalmill.net/2024/10/03/extracting-json-object-keys-in-power-automate/

- Writing expressions in Power Automate: https://digitalmill.net/2024/02/27/writing-expressions-in-power-automate/

- Dynamic content in Power Automate: https://youtu.be/jpledJfaEPQ

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn

Was this reply helpful? Yes No
DS-12051116-0 4 on at

Like (0)

Report

Thanks for your answer.

Via this way I maybe get the dynamic content behind the numbers, but now I want to store them in some kind of 'new' dictionarry so I can access them in future compose actions to get the individual results. Can you explain a bit more how it will look like inside the for each loop to store them all into a dictionarry?

Was this reply helpful? Yes No
DS-12051116-0 4 on at

Like (0)

Report

Hi @rzaneti,

In addition to my other comment..
I also get stuck with getting the keys from my output because it is recognized as an object. And the function 'first' like you mentioned in the article or the apply to each function won't work on objects. Sadly I am not a super expert in Power Automate, I understand I maybe ask for a lot but can you maybe try and give some more specific formules, steps based on my exact case?

For further info, the output that is shown in the original post is already from a compose action.

Was this reply helpful? Yes No
rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi @DS-12051116-0,

No worries at all! I will be glad in providing you a more specific step-by-step :) Before that, can you share a sample on how would your desired output (the new dictionary) would looks like?

Was this reply helpful? Yes No