Power Platform Community Forum Thread Details

We recently moved away from SQL Server Authentication to a new security method for our SQL Database where we only use Azure Active Directory. As I try to change the authentication method for probably 50+ SQL actions in our flow library I get this error. Looking at the code of the action it looks like the path key in the JSON is missing the SQL Server and Database (although it still has the table name). This is extremely frustrating as the only way I can think to fix this issue is to rebuild every single SQL action in my flows when all I am doing is trying to switch the authentication method to something more secure.

I've tried downloading the zip file and editing the JSON but it uploads with error no matter how careful I am.

2022-11-11 15_04_35-Edit your flow _ Power Automate and 14 more pages - Work - Microsoft Edge.png

Example of code error after switching from the SQL Server Authentication connector to the Azure AD Connection method.

"path":"/datasets/default/tables/@{encodeURIComponent(encodeURIComponent('[dbo].[xxx]'))}/items"

What would work if I recreated the SQL Action with V2

/v2/datasets/@{encodeURIComponent(encodeURIComponent('xxxxxserverendpoint'))},@{encodeURIComponent(encodeURIComponent('databasename'))}/tables/@{encodeURIComponent(encodeURIComponent('[dbo].[xxxx]'))}/items

any suggestions or ideas would be helpful. This migration from SQL Server Auth to Azure AD Password + conditional access has been a nightmare on the Power Automate flow and I wish Microsoft would make this kind of thing easier.

Categories:

Using connectors