Issue with SQL API connector - Some of the connections are not authorized yet.
I am copying the same issue from another person. This seems to be a new bug.
My flows connecting to Azure SQL stopped working today as the lost the SQL connectoin I set up. Trying to set the sql connection again I get below error.
Some of the connections are not authorized yet. If you just created a workflow from a template, please click Continue to add the authorized connections to your workflow before saving.
I tried re-adding connection multiple times, but can't get pass this
Please create a support request if this is still an issue
@Thibault Liardon - Your solution worked perfectly, though I'm not sure why it did.
We had an ex-employee who had is old email/Azure AD account registered in the API Connection for a LogicApp. I couldn't get rid of the connection in the designer either - even after creating a new one. I had to do two things - go to 'API Connections' and delete any of them registered/associated with a user that does not have authorization. Then I ended up just modifying the LogicApp json directly in code view to point to the new connection I had made. This is a woeful lack of feature in the LogicApp designer imho, it should allow the developer/designer to add/remove connections fully from the designer toolset - not have to munge other settings outside of the designer and especially not in the json itself.
Thibault Liardon commented
We have the same problem.
However, I suggest you try this workaround:
* You see the error message in the designer.
* Switch to « Code view ».
* Save the Logic App.
* Switch back to « Designer ».
Now you should be able to work with the designer as usual.