Unanswered

Issue with Create HTML table from SQL Query

(0) Share

Report

Posted on by cdebloi

I am trying to build a flow that takes data from a SQL query (using 'Transform data using Power Query') and essentially formats it into an HTML table that I can send via an email. The flow automates sending out the email weekly with the results of the query. I think I am close but keep running into an issue with the "Create HTML table" where the error reads: "BadRequest. The property 'columns' must be specified unless the 'form' property value is an array of objects." Though I'm not quite sure what I need to do to fix it.... all the solutions I can find online seem to work for people using Get Items from a Sharepoint list but I can't find anything that comes from a SQL Query. Appreciate the help!

Ex.// My SQL Output body/value is

[

{

"Run": 1308103,

"Weeks Sales": 6,

"Customer": "FPL",

"Weeks Start": 10,

"TSR": "Chris",

"Engineers": "Jim, Joe"

{

"Run": 1262842,

"Weeks at Sales": 4,

"Customer": "Farmers Inc",

"Weeks to FA Start": 10,

"TSR": "Paul",

"Engineers": "Bob, Joe"

}

]

I then Parse JSON, run through some steps in the flow, then send the email.

The "style" is just a format style for the HTML table but maybe I've got an error in there but that isn't where the error in the flow is showing up.

</style>

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

v-yueyun-msft on at

Like (1)

Report
Re: Issue with Create HTML table from SQL Query

Hi , @cdebloi
According to your description, you have got the data like this:

[ { "Run": 1308103, "Weeks Sales": 6, "Customer": "FPL", "Weeks Start": 10, "TSR": "Chris", "Engineers": "Jim, Joe" }, { "Run": 1262842, "Weeks at Sales": 4, "Customer": "Farmers Inc", "Weeks to FA Start": 10, "TSR": "Paul", "Engineers": "Bob, Joe" } ]

So you can just use this array in your "Create HTML Table" action:
And for your css code , you ca also put it in a Compose action and then put it in the body of the "Send an email v2" action:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Verified answer

cdebloi 19 on at

Like (0)

Report

Re: Issue with Create HTML table from SQL Query

After doing some re-thinking and mapping out the flow on paper, I was able to simplify it down and get the desired output I wanted. Here is the new flow for reference. The "Select" should've bene my first step to turn the JSON from the SQL Query into an array format for the HTML table rather then going through and creating an array the other way that was causing me issues with the column headers

Was this reply helpful? Yes No
cdebloi 19 on at

Like (0)

Report

Re: Issue with Create HTML table from SQL Query

Yep - solved my problem after I went back at it building my flow from scratch. We had very similar answers. I appreciate the reply!

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

Re: Issue with Create HTML table from SQL Query

Hi , @cdebloi
Thanks for your quick response! Do you mean you have solved by yourself , Oh good news to hear that!!
If convenient , can you mark the replys which is useful for this case which can help more people!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No