Logic App will not write to Azure SQL DB/ Connector will not load tables

Jagdeep 1 Reputation point
2022-08-16T14:43:22.793+00:00

Hi,

I'm having an issue where after inputting a sql connection string, the logic app 'Insert Row' function will not load the list of tables

To get around this I can input the table name manually but after this when trying to specify column name and data to insert, the flow will fail

The connection does work as I was able to insert null rows (by not specifying column name), and the column name is correct

Has anyone seen the same issue?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,839 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MayankBargali-MSFT 68,471 Reputation points
    2022-08-25T13:38:12.517+00:00

    @Jagdeep Thanks for reaching out. It could be due to the limitation as mentioned here. I couldn't reproduce the issue at my end. But to find the root cause of the issue we need to review the logs as you may have observed this issue due to any of the limitations as mentioned in the connection document. In case if you still observe the same behavior please let me know so we can connect offline to assist you further.

    0 comments No comments