web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need Help pulling data...
Power Automate
Unanswered

Need Help pulling data out of a forms object

(0) ShareShare
ReportReport
Posted on by 2

So I am trying to grab the data out of a MS Form so that I can do some calculations with the values. Here is what the body object looks like.

 

"body": {
        "responder""zack.trapp@xxxxx.com",
        "submitDate""11/5/2021 2:47:24 PM",
        "ra9419ce7fca644759b6bfcf3af8899f6""10",
        "r63fe941740974eaf85904147987ad1dc""",
        "rdb19ec15a64549589f1914ab5f59bf15""",
        "rf587a8b0b60b4eb5a85dffa4a368eb9a""0",
        "r4426d8b5507b47ad8554175d7aa04eb3""10",
        "r6955c104e52f4318afa438bb37b2f557""9",
        "r188903c97bf84979a610d80a1964ebfd""Joe Peh",
        "r2e04a625f4fb43a9ba31459dfe15211b""",
        "re1885f0032a445ee910f9e17771a849a""",
        "read674dad122484db3c7e50552a91e0e""",
        "r938ad40659524fdaaa5c33dac9202105""10",
        "rcf45ab38a8a746b29f0cdb8f28bc2acc""",
        "raeead1455bcb4902897d3b1ddbb0422b""6",
        "rd40fdfefdf7f4fdfbcd3ac540b9261e5""6",
        "r73b42141da5143b49713875331719c8e""X-Ray",
        "r1b59d1b353044a66986d9b2537c2891e""6",
        "r3a9c4b099c5148aaa60b8cca2a0ae4ae""0",
        "rd325dc3846d64ce09ef416c17518272e""",
        "r6179b16a195d455ab651d8d6358591a6""",
        "re2608d6c813f46b3adc5ef0de38caf98""North Office",
        "rd1aa45ffb48d4084a1f6a93d745272be""",
        "r0f28276b9bde45988ea0b00167a4f12b""0",
        "rc00e949140504ae58de884ef37a91616""5",
        "rfc59d16425a74dc39fd388352494183b""",
        "rde9cdb15460f48feb17fc9ee2ccc87a1""2021-11-05",
        "re89a99014724498fb274f2f225d9b042""5",
        "r82244dd89ae64fd083aca0c0f1cbd5de""",
        "r241b40ccd9e2420080c30d3bc87ae967""Zack Trapp",
        "rbef237fec0d74e469c4ef5bf7c76c2ca""0",
        "r06cbff39fbd44f0a84b490224bb361d0""",
        "r941f09960b8d4d90bd5306a42f21d00b""",
        "rc1a2db2cba9440ee8baecc7093744a8b""",
        "r298afcf9e4e943bd878d7645b0ae1bc5""3",
        "r2f9c1bc036c74725a3cb2dec35b0f53e""",
        "r9670511b8a3f44dd81285a7502be899b""",
        "r2a96d38ede9341cd94273650b9153f08""0",
        "r597e10bc10214abf8881113de87fa150""2",
        "r0d9c76a4e2be45d695a5c8298a91736b""10",
        "r611dfc0e52ac46358a0e60f154e04317""10",
        "rf443b9f705cf490e879e854dd97836e0""",
        "r1289a860ead6409e9728be7ab1b4d7c8""8",
        "r9ed0c2d147bc485d97b84ce7305c3f8e""",
        "r840e436a92e249d4ba00e0eb84a2942f""",
        "r7cadcf906bb144d6abba69440054cd60""5",
        "rd4833c0bada44112b57b7d8038ec5782""",
        "r4733777432a442aba586cf7e1529a3e7""1",
        "r5c41961456094e1690e12e4d4a9e7880""",
        "r860af7aaa8dd41abb99ce3523bd31135"""
    }
 
I just want the Int values and made an array containing the Key values but that doesn't seem to actually do anything.
 

"ra9419ce7fca644759b6bfcf3af8899f6"

"rf587a8b0b60b4eb5a85dffa4a368eb9a"

"r4426d8b5507b47ad8554175d7aa04eb3"

"r6955c104e52f4318afa438bb37b2f557"

"r938ad40659524fdaaa5c33dac9202105"

"raeead1455bcb4902897d3b1ddbb0422b"

"rd40fdfefdf7f4fdfbcd3ac540b9261e5"

"r1b59d1b353044a66986d9b2537c2891e"

"r3a9c4b099c5148aaa60b8cca2a0ae4ae"

"r0f28276b9bde45988ea0b00167a4f12b"

"rc00e949140504ae58de884ef37a91616"

"re89a99014724498fb274f2f225d9b042"

"rbef237fec0d74e469c4ef5bf7c76c2ca"

"r298afcf9e4e943bd878d7645b0ae1bc5"

"r2a96d38ede9341cd94273650b9153f08"

"r597e10bc10214abf8881113de87fa150"

"r0d9c76a4e2be45d695a5c8298a91736b"

"r611dfc0e52ac46358a0e60f154e04317"

"r1289a860ead6409e9728be7ab1b4d7c8"

"r7cadcf906bb144d6abba69440054cd60"

"r4733777432a442aba586cf7e1529a3e7"

 

any help would be appreciated I'm new Flow I have usually used the Desktop version.

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    68,697 Most Valuable Professional on at

    You can use the 'Get Response Details' to load all the answers as dynamic content automatically based on a form submission.  You don't need to grab the data manually.

  • Zack_Trapp Profile Picture
    2 on at

    I was aware of that my issue is that I want to grab the data through a loop if possible because I need to grab the responses of about 20 questions. I may just be coming at this wrong but I know I can grab it from each separately but that would become a mess for me very quickly and I will need to do the same for other forms in the future.

     

  • Pstork1 Profile Picture
    68,697 Most Valuable Professional on at

    Unfortunately, the answers to the questions are not provided in an array and therefore can't be sed in a loop.  To use them in a loop you would need to create an array variable and then append each response to the array individually.  There is no way to take the individual properties and turn them into an array and no way to use them as they are in a loop.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard