question

schourey-0511 avatar image
0 Votes"
schourey-0511 asked ·

Azure Logic Apps Order By SQL

I have set an alert on logic apps to run a sql view and format the result in HTML table. The problem is even though I have order by clause, the result in HTML table is not sorted in order.

Also, Is there any way on logic apps, I can create multiple HTML tables with different where conditions from sql query

azure-logic-apps
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@schourey-0511 Thanks for the question. We will review and update at the earliest.

0 Votes 0 ·

1 Answer

JayaC-MSFT avatar image
0 Votes"
JayaC-MSFT answered ·

@schourey-0511 We did not receive any proper code or example to see why the "Order by " clause is not working. So I am sharing couple of relevant links :

https://www.serverlessnotes.com/docs/in-order-message-delivery-using-azure-logic-apps

https://docs.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver15

If it doesn't help, please share more details on how you are achieving this.

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I am using Execute a SQL query (v2) and I dont see different parameter for order by clause

0 Votes 0 ·