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
Awesome it works.. thank you so much..
small suggestion after making change in Design view just go to Code view and save, Its working.
No need to go back to the design view
@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.