Answered

Columns Missing When Importing from Excel CSV

(1) Share

Report

Posted on by fmc1

I am trying to import Excel CSV data into a custom table. I created a table and added three optional text columns. Saved and published the table. I used "Data | Get data from Excel" and selected a CSV file. After a moment it gives mapping errors and when I click the Mapping button my new columns are not available for mapping. The only columns that appear are core table columns. I do see all of the CSV file columns. I dropped and recreated the table several times but cannot map the new columns. After some digging I am finding this to be the case on my 4 custom tables.

Any thoughts?

Thank you.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (2)

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Hi @fmc1,
Just tried the same thing from my side and cannot reproduce. It can be some kind of caching. It shouldn't make a difference but have you tried to publish all customizations? Also, try it in the preview version of the Maker portal: https://make.preview.powerapps.com

Hope this helps!

Was this reply helpful? Yes No
fmc1 37 on at

Like (0)

Report

This appears to be some sort of Dataverse caching issue. I tried dropping the table SalesData and recreating with the same name and adding the same custom columns but the import still does not see the columns. I then created a MySalesData table and added some of the custom columns and this time the import showed the columns. I then added more columns to MySalesData, saved and published, but the new columns do not show on the import screen. I then deleted table MySalesData, created a new table with the same name and added all of the custom columns but the import shows none of the custom columns. The only way around this is to created another table with a different name and add all of the custom columns the first time. This is not manageable and this must be some underlying issue.

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report

Yeah... I would submit a support ticket at Microsoft at: https://admin.powerplatform.microsoft.com/support

But the other options you have to import CSV are:

1) Power Apps Office Add-In to do it directly in Excel: https://appsource.microsoft.com/en-us/product/office/wa104380330?tab=overview

2) Dataflows with a CSV as a data source: https://docs.microsoft.com/powerapps/maker/data-platform/create-and-use-dataflows

3) Classic Data Import Wizard: https://docs.microsoft.com/power-platform/admin/import-data-all-record-types or https://docs.microsoft.com/dynamics365/customerengagement/on-premises/basics/import-accounts-leads-other-data
Hope this helps!

Was this reply helpful? Yes No
Verified answer

BaptisteW 124 on at

Like (0)

Report

1.5 year later, same problem

EDIT: Use the "Import data" instead of "Import data from Excel", you should be fine

Was this reply helpful? Yes No