Answered

Import Excel to Dataverse

(0) Share

Report

Posted on by jed76

I can't quite understand what I am doing wrong here. I am trying to import a simple Excel file with numerous columns into a Dataverse table.

I have created a new Dataverse table and created some columns which I want to map to the Excel columns. However, whenever I choose toe IMPORT DATA FROM EXCEL, I can only see the PRIMARY column (in this case 'NAME') and also a column labelled the name of the table. All other columns which I have created aren't in the list to map to? I can see some standard columns, but none of the ones which I have created?

Any thoughts?!

Best wishes.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

AhmedSalih

6,680 Moderator on at

Like (1)

Report

Copy link

Link copied!

Hello, @jed76, as best practice and straight forward approach to import data from Excel into dataverse, use the Dataflows. Here is my full tutorial for how to do that: https://powerplatformplace.com/f/excel-to-dataverse-migration---part-1

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

jed76 on at

Like (0)

Report
Copy link

Link copied!

Many thanks - I shall give it a try!

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

@jed76 , happy to help and let me know if you need further assistance:)

Was this reply helpful? Yes No