Friday, October 7, 2022

How to Fix Microsoft Flow Error : 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.'}}'.

Introduction:


In this Blog we will see how to fix Microsoft Flow error - InvokerConnectionOverrideFailed


Implementation Steps:

 

Consider while creating a new Power Automate Flow which contains Excel or SharePoint. Once After 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.

 

rampprakash_1-1665125168560.png

 

 

Why this Issue Occurs?

 

This is Because the 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

 

rampprakash_0-1665125131254.png

 

4. Once You Click on Run it will Load the Popup with Respective Connections ( All the Connection with Current Microsoft Flow is Required) 

 

rampprakash_2-1665125283512.png

 

 

5. Once after it is Success you are Good to Trigger the Flow.

 

Refresh the Screen and Start Working :slightly_smiling_face:

 

Resolution 2 - Below Steps need to Be Followed before Flow Gets Created:

 

1. Navigate to https://make.powerautomate.com

 

2. Click on Data --> Select Connections

 

rampprakash_0-1665124684474.png

 

3. Click New Connections

 

rampprakash_1-1665124751487.png

 

4. Search for the Respective Properties Item to Use (like Excel, SharePoint, Dataverse etc.,.)

 

rampprakash_2-1665124821163.png

 

5. Select the Respective Item --> Once Selected it will Show you a Popup to Create a Connection

 

rampprakash_3-1665124871609.png

 

6. Click Create

 

7. Once After You 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 :slightly_smiling_face:

 

2 comments:

  1. Excellent, it worked perfectly. I had to delete one flow and start over before I found this article. After I Run the flow the connection came back. Thank you very much!

    ReplyDelete
  2. This worked! Thanks for the info

    ReplyDelete

How to disable Form JavaScript Using URL in Model Driven app and MSCRM

  Introduction : How to disable Form JavaScript Using URL in Model Driven app and MSCRM . Implementation Steps: Navigate to your Environment...