web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Dataverse table column...
Power Apps - Microsoft Dataverse
Unanswered

Dataverse table columns not showing up when importing excel

(0) ShareShare
ReportReport
Posted on by ChrisPBacon 24

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
I have the same question (0)
  • RobHardy Profile Picture
    RobHardy 154 on at
    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

  • ML-05080805-0 Profile Picture
    ML-05080805-0 4 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes happening today, December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans