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:
- trigger: "When a new response is submitted"
- action: "Get response details"
- action: "Create HTML table"
- 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?
