Error when importing data into entity

(0) Share

Report

Posted on by Community Power Pla...

Hi there! I'm constantly getting an error when importing data from Excel into entity:

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Also when importing the csv-file, the message is as following:

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report
Hi @Anonymous ,

Not sure what is happening on you, but here is alternative workaround from Dynamics (Reference from here) which seems to be more reliable and consistent.

The Detailed steps.

Go to solution explorer

Remove everything after dynamics.com in the url and hit enter

Go to Settings > Data management

Imports

Choose EXCEL TEMPLATES> Create excel template

Select template to create: Excel template (defaults to this)

Select Data:

Filter by entity:

Used saved view: Choose a view of the entity—do you know how to make views?: https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/dn509... (I can show you on a call if you’re interested.)

Click download file

Open the downloaded .xlsx file

Populate the data into appropriate columns into the spreadsheet

Save and close the spreadsheet

Go back to the dynamics imports page and click IMPORT DATA

Choose the spreadsheet

Click next

Choose whether or not to allow duplicates and select owner

Click submit

Hope this helps.

Sik

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous, if your issue is still not resolve, I would suggest submitting a Microsoft Support ticket at: https://admin.powerplatform.microsoft.com/support

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

Thank you all for helping! I tried to delete the whole environment (it was trial) which was the wrong move, because the environment I created after had disappeared from the list. Now I can't create a new one (says that I already have a trial environment) though the list of environments is empty. Working on the issue with the help from Power Platform Support. If the issue will be resolved I'm going to try to import excel data as you've written here before.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I deleted the whole environment to start from scratch, and now it's working fine. Thanks for your replies!

Was this reply helpful? Yes No