Introduction
In this blog, we will see how to fix InvokerConnectionOverrideFailed error in Microsoft Flow.
Implementation Steps
Consider creating a new Power Automate Flow which contains Excel or SharePoint. Once you done with your flow while triggering/testing the flow sometimes you will get Request to Azure Resource Manager failed with error: '{"error":{"code":"InvokerConnectionOverrideFailed","message":"Could not find any valid connection for connection reference name 'shared_excelonlinebusiness' in APIM tokens header."}}'. this error.
Why this Issue Occurs?
This is because while creating the Flow you are trying to add a new Connection within the flow like adding an Excel (it will automatically create a Connection or SharePoint etc.,.)
How to Resolve this Issue?
There are couple of ways we can resolve this issue
Resolution 1 - Below Steps need to be performed once the flow gets created :
Once the flow gets Created
1. Navigate to https://make.powerautomate.com
2. Click My Flows
3. Select the Flow and click on RUN
4. Once you click on Run it will load the Popup with Respective Connections (All the Connection with Current Microsoft Flow is Required)
5. Once it is a Success you are good to trigger the Flow.
Refresh the Screen and start working
Resolution 2 - Below are Steps needed to be followed before Flow gets created:
1. Navigate to https://make.powerautomate.com
2. Click on Data --> Select Connections
3. Click New Connections
4. Search for the Respective Properties Item to Use (like Excel, SharePoint, Dataverse etc.,.)
5. Select the Respective Item --> Once Selected it will show you a Popup to create a Connection
6. Click Create
7. Once you have done this you are food to Create Microsoft Flow, now if you try to add a new connection it will Automatically fetch it from the Respective Connections which we have created.
That's it :)
Above mentioned resolution Steps, will help you to fix InvokerConnectionOverrideFailed issues in Microsoft flow.