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:

 

No comments:

Post a Comment

Day 11 - Customizing Option Sets Dropdown Fields with JavaScript

  In this Blog, we will see how to Customizing Option Sets Dropdown Fields with JavaScript label1 = formContext.getAttribute( "bosch_op...