Unanswered

Trying to build a flow that will add a table into an email using responses from MS Forms

(0) Share

Report

Posted on by Wolfeman

I am trying to add a table into an email using responses from MS Forms to populate the table (See Flow below for details) , but I keep getting error: BadRequest. The 'from' property value in the 'table' action inputs is of type 'Null'. The value must be of type 'Array'.

I am trying to create a flow that will mimic the email below where my colleague's email has a small two column table. (Below that is my Flow)

Thanks!

Kindest Regards,

Wolfeman

All responses (3)

Answers (0)

Pstork1 67,047 Most Valuable Professional on at

Like (0)

Report

Re: Trying to build a flow that will add a table into an email using responses from MS Forms

The problem is that you can't create an HTML table from a string using that action. You need an array. Since all the responses come in as individual answers there is no simple way to group them into an array. So you need to do something like this.

1) Get the details of the response and then Initialize an Array variable.

2) Then append each question and answer to the Array variable like this. (The braces and format are required.)

3) Now you have an array that you can convert to an HTML table.
Wolfeman 12 on at

Like (0)

Report

Re: Trying to build a flow that will add a table into an email using responses from MS Forms

Thanks Pstork1! I appreciate the response, I am trying to Insert the Response information into an HTML table in String format...but I'm not sure how to do that, here is my progress, but at this point I am just guessing...
Pstork1 67,047 Most Valuable Professional on at

Like (0)

Report

Re: Trying to build a flow that will add a table into an email using responses from MS Forms

The problem is that the responses from an MS Form aren't returned in the form of an array. They are returned as individual data elements. So you can't just create an HTML table from them directly. You'll need to either append them to an array and convert that to a table or insert them into an HTML table in string format.