How to get response from form in key-value (field-name:field-value) format?

[RredCat]

I have a simple workflow implemented in Power Automate. A user fills out a form, and it triggers my flow, where I extract a response and send it in an email.

I use next actions:

1. trigger: "When a new response is submitted"
2. action: "Get response details"
3. action: "Create HTML table"
4. action: send an email.

My issue is that on step 2, I get as output something like the:

[
  {
    "responder": "name.surname@abc.com",
    "submitDate": "4/25/2019 3:48:26 PM",
    "r92de569b263d4dd2856237db53eae005": "Name",
    "r180d3b4446d8430d9bb5d2299153840d": "Surname",
    "rc81933a57345466b963c4a87e4255816": "45"
  }
]

All values don't have relevant keys. I could format an email without 3td step. But in this case, I have to format the email body manually, I have to add each value in the body, something like I did with Comments:

But, the form that triggers this flow is changeable, and I don't want to edit the flow for each new field added/removed to the form. So, I want to convert all fields to html and put it in the email.

My expectation from the 2nd step is the following:

[
  {
    "responder": "name.surname@abc.com",
    "submitDate": "4/25/2019 3:48:26 PM",
    "First Name": "Name",
    "Second Name": "Surname",
    "Age": "45"
  }
]

How to achieve this?

[Pstork1]

The keys that you get when you run Get response details are the GUIDs that represent the questions. This is done because the text of the question on the form could be quite long and wouldn't be a suitable key.  If you want to use more user friendly keys to create the HTML table you can add a Data Select action between steps #2 and #3 to remap the output and provide your own keys for each column.

[RredCat]

Hi,
Thank you for your answer. I thought about this step as well. But in this case, I have to do a manual map on the Data Select step. I want to avoid any manual mapping in this flow.

[Pstork1]

I don't know of any way to retrieve the question text to use that in the flow.  Some form of remapping is really your only option.

[RredCat]

I am surprised that I can't find this option. I have up to 200 questions that change from time to time after employees' feedback. I want to assign validation to responsible persons on the fly.

[Pstork1]

But if the form changes you'll need to re-do the flow anyway.  The schema of the form is cached in the flow connection when you create it. If you change the form you need to redo the connection.  I wish you could access the questions too, but that option isn't available at this point.

[iBro]

You can get the questions from MS Forms using HTTP connectors.

In this example, I am using Get web resource action from HTTP with Microsoft Entra ID connector.

The URL to fetch is : https://forms.office.com/handlers/ResponsePageStartup.ashx?id=FORM_ID

Then you decode the result and select the formsProRTQuestionTitle property.