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

Jagdeep 1

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?

Kamlesh Kumar 3,861 Reputation points

2022-08-17T05:06:16.157+00:00
Hi @Jagdeep ,

Welcome to Microsoft Q&A Platform. Thank you for the question.

We would need some more details here to replicate this as our end, kindly share the details,

Which type of logicApp you are using, consumption or standard ?

Possible to share the screenshot of your workflow?

Possible to share the steps to replicate it?

Regards,
Kamlesh Kumar

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is How

Want a reminder to come back and check responses? Here is how to subscribe to a Notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

1 answer

MayankBargali-MSFT 70,016 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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment