Power Platform Community Forum Thread Details

Good day,

I have a SQL connector connected to a on-prem SQL Server 2016 database. I have a number of flows which are still running using this connector on a daily basis. However when I try to create a new flow using this same connector (or a new one) when I enter the connector parameters I am now receiving an error when Power Automate is trying to retrieve the Table name drop down list.

"The dynamic invocation request failed with error: {"status":400, "message":"Microsoft SQL: Invalid column name 'Source_Code_Type'"}"

looks like something may have changed, can anyone offer any help?

Kind Regards

Colin

Categories:

Using connectors