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

Community site session details

Session Id : s9ynOclaRso2qBwF2oploi
Power Automate - Building Flows
Answered

2 fields from my form are not populating to my excel table

Like (0) ShareShare
ReportReport
Posted on 14 Feb 2024 09:01:29 by 75

Hi,

 

2 questions on my form are not populating my excel table. Description of PM and Job Risk

Rogan_0-1707901155286.png

All other questions that I answered worked fine, just them two.

Rogan_1-1707901221112.png

one is a multiple choice and the other is just a text answer.

Any help is much appriciated.

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on 15 Feb 2024 at 03:51:13
    Re: 2 fields from my form are not populating to my excel table

    Hi @Rogan,

    To parse multi choices from form response, you need to use json() as below:

    vqiaqimsft_0-1707968980325.png

     

  • Rogan Profile Picture
    75 on 14 Feb 2024 at 12:40:14
    Re: 2 fields from my form are not populating to my excel table

    Hi @rzaneti,

     

    here are my raw outputs

    Rogan_0-1707914346889.png

    the answer to job risk is "Low" and the answer to description of PM is "fgfd"

  • Verified answer
    rzaneti Profile Picture
    4,096 Super User 2025 Season 2 on 14 Feb 2024 at 12:11:31
    Re: 2 fields from my form are not populating to my excel table

    Hi @Rogan ,

     

    Let's investigate. Could you please share an image of your raw outputs from the "Get response details" action?

     

    To get the raw outputs, you just need to navigate until the action in any flow run, expand it and click in "Show raw outputs":

    rzaneti_0-1707912495350.png

     

    After that, a JSON will be displayed on the right side of your screen, and this is the raw output:

    rzaneti_1-1707912574871.png

     

    Also: (1) make sure to remove any sensitive content from the image before sharing it and (2) please refer which are the answers in the raw outputs related to Description of PM and Job Risk (as you can see per my image, the form questions are represented by a not user-friendly id).

     

    If you need additional instructions on how to access the raw outputs in Power Automate, refer to this article: http://digitalmill.net/2023/06/29/how-to-access-the-raw-outputs-in-power-automate/ 

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete