Unanswered

Create an HTML Table from MS Forms responses

(0) Share

Report

Posted on by Community Power Pla...

I'm struggling to generate an html table filled with responses of a MS Forms, i'm using this approach:

https://powerusers.microsoft.com/t5/Building-Flows/Create-HTML-Table-from-MS-Flow-inputs/m-p/482273#M59069

However, the issue is that i have several key-value pairs filled in a same form, tried to solve it by putting them in the same sentence, this is an example with the two first groups of answers of the same form reply, by using the method above:

however, in this way, only the last group of values is appended and included in the HTML Table

is it something i'm coding wrong in the json parsing side of the append? tried with different vignete configurations and only this one showed as a valid json sentence.

this is my expected Table output every time the form is submitted:

CCMS Number	Begin Time	End Time
CCMS1	Beg1	End1
CCMS2	Beg2	End2
CCMS3	Beg3	End3
CCMS4	Beg4	End4
CCMS5	Beg5	End5

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

fchopo 8,003 Moderator on at

Like (0)

Report
Hi @Anonymous

In the "Append to array variable 2" you should append 2 items and not one, using the following expression:

[ { "CCMSID": "...", "Beg_Time": "...", "End_Time": "...", }, { "CCMSID": "...", "Beg_Time": "...", "End_Time": "...", } ]

Using [ ] you're creating an array, which will have 2 items (using {} and using "," as separator").

Hope it helps!

Ferran

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thanks @fchopo ! however, with this structure, im getting an error in the create HTML table module,
this one when I setup the columns automatic:

this one if I set it custom and each value as item()?['...']
When I use this structure with only one case:

I got good results, and it seem like the create HTML Table module adds the [] brackets:
but without the brackets in the append when I try to get more than one case, it shows that is not a valid json

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (2)

Report

finally got the workaround: append each case in an individual module:

Was this reply helpful? Yes No
Ankitxev 4 on at

Like (1)

Report

You can use HTML code to create a table in the email and use results from form:

Was this reply helpful? Yes No
Mia_ 20 on at

Like (0)

Report

I'm struggling with the same thing, you can't just pick the form to make the base data of HTML (like you could a sharepoint table!)

Why does everything have to be so hard and messy (?!)

Was this reply helpful? Yes No