You’re offline. This is a read only version of the page.
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:
My issue is that on step 2, I get as output something like the:
Share
Report[
{
"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?
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.
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.
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.
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.
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.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
All responses (
Answers (
