Azure Logic Apps Order By SQL

schourey 1 Reputation point
2021-02-26T18:31:28.233+00:00

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
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,873 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. JayaC-MSFT 5,526 Reputation points
    2021-03-08T10:17:01.723+00:00

    @schourey 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://learn.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.