Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Import Excel file into Dataverse table with Look up columns

(0) ShareShare
ReportReport
Posted on by

Hi All,

 

I have a basic problem that I can not seem to resolve.

 

I have a table (tblTools) as per the attached ER Diagram that I have created in Dataverse.

 

For the testing of the app I entered data into the table though my Canvas app with no issues.

I am now ready to import my production data from excel into the tblTools. I have tried using both Import options from within the table in Dataverse but both my lookups columns are missing (Please see attached screenshot)

 

All I require method of importing over 3k records into a Dataverse table with all the columns

 

Any help is appreciated

 

Categories:
  • Luis Arellano Profile Picture
    Luis Arellano 247 on at
    Re: Import Excel file into Dataverse table with Look up columns

    Hi, what is the error you are getting when importing?

  • AshleyTaylor Profile Picture
    AshleyTaylor on at
    Re: Import Excel file into Dataverse table with Look up columns

    @LuisArellano Thanks for your suggestion but when I select all columns the import fails.

  • Luis Arellano Profile Picture
    Luis Arellano 247 on at
    Re: Import Excel file into Dataverse table with Look up columns

    Instead of IMport Data, you can try "Import data from Excel"

     

    LuisArellano_0-1688087030103.png

     

    Select your .xlsx or .csv file and click "Map columns"

     

    LuisArellano_1-1688087064184.png

    If you do not see your lookups, show "All Columns"

    LuisArellano_2-1688087141449.png

     

     

     

     

     

     

     

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics