How to Create Record in Dataverse - Excel Import

Introduction: 

In this Blog we will see how to import record in Dataverse using Excel.

Implementation Steps:

 

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

 

2. Choose the Table where you want to Import the Record, in my case am Choosing Account Table

 

3. Now click Gear Icon at the Top then Select Advance Settings (For Legacy)

        Else Select Table --> Open Account --> Click Export

 

4. In my Case Am Taking Legacy Mode and Select Advance Find then Select Account Table and Click Result

 

 

5. Once the Page Loaded Select Export Accounts and Select Static WorkSheet

 

6. Once the Excel Downloaded --> Open the Excel and Remove the Rows which is available and Add a New Record which you want to create in Dataverse Account Table

 

7. Now once the Record added in a Row then Save the Excel as CSV format

 

 

 

8. Once Saved Go the Point 2 Again and Select Data Management and Select Imports

 

 

9. Click Import Data at the Top of the Ribbon

 

10. Now Choose the File (Saved .csv format)

 

 

 

11. Click Next and Select Next again and Select Default(Automatic Mapping)

 

 

 

12. Select Account as an Entity and Click Next

 

 

 

13. Now the Field will get mapped successfully if it is not mapped then Map the correct fields and Click Next

 

14. Select the Owner and Select weather you want to allow duplicates or not and Click finish

 

 

15. Once done you can able to see the Status of the Record

 

 

16. Once the Status Reason is Completed you can able to see the Records in your Dataverse Environment 

 

 

That's it 

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.

 

 

 

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

 

 

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 after it is Success you are Good to Trigger the Flow.

 

Refresh the Screen and Start Working 

 

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

 

 

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 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