Unanswered

Dataverse table columns not showing up when importing excel

Like (0) Share

Report

Posted on 22 Nov 2022 00:41:46 by ChrisPBacon

I'm trying to import an excel file and when it comes to mapping the appropriate columns, the columns in the dataverse table do not show up except for a couple like Name, status reason, etc.

edit: I was able to import the file by creating a canvas application with the table and importing it that way.

Categories:

Microsoft Dataverse

All responses (2)

Answers (0)

ML-05080805-0 4 on 11 Sep 2024 at 12:05:15

Like (0)

Report

Dataverse table columns not showing up when importing excel

I'm having the same problem, where a column is not showing when trying to map the data from Excel. I have not yet been able to find a solution.

Edit: I solved it by exporting the table, and when I tried mapping my import again all the columns magically showed up.
RobHardy 154 on 22 Nov 2022 at 10:58:14

Like (1)

Report

Re: Dataverse table columns not showing up when importing excel

Hi @ChrisPBacon,

Good you found a solution, but (for future reference), were the missing columns Lookups against other tables?

If so, the other (parent) table(s) needs to have an alternate key set (i.e. a column containing unique values which can be used to lookup the records from the data in the Excel sheet). Setting the key allows this column to then be displayed in the Dataflow. This tutorial from @AhmedSalih helped me with the same issue:

https://powerplatformplace.com/f/excel-to-dataverse-migration---part-1