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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / unable to Import data ...
Power Apps
Answered

unable to Import data into Dataverse table with a lookup field for model driven application

(0) ShareShare
ReportReport
Posted on by 83

Hi folks,

I'm testing Power Apps Model driven apps, I have created 3 custom tables like

 

-Table1

Donate_ID (auto)

Value_price

Product Name(dropdown) -   lookup view with ID and name

Location -   lookup view with ID and name

 

-Table2 

 Product Name

 Product_ID

 

- Table 3

Location ID

Location Name

City

 

 

Table 1 has form where users can enter and select drop downs.

Existing data need to be imported from SQL and im unable to get data for Table 1 and i think it is because of lookup field. When i remove lookup fields im able to import data.

I couldn't find much documentation regarding this import to datavers (CDS) with lookupfield, did anyone face this issue? 

Any support much appreciated 🙂

 

Thank you

I have the same question (1)
  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @My_connect,

    How exactly are you import the data/records? Dataflows, Excel, Excel Online, etc? If you don't have a lot of records, suggest to use the Office Add-in, it works quite well and have intellisense/smarts for lookups and whatnot: https://docs.microsoft.com/powerapps/maker/data-platform/data-platform-excel-addin 

    Hope this helps!

  • My_connect Profile Picture
    83 on at

    SQL to Dataverse

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    SQL to Dataverse is not a Power Platform component so hard to determine... can you share a screenshot please?

  • My_connect Profile Picture
    83 on at

    Once I select tables from SQL and select 'load to existing table' and column mapping is were the problem is,

    My_connect_1-1614578875971.png

    last step, after I select Create, records do not load to the table.

    My_connect_2-1614579429943.png

    If i remove lookup fields , im getting the data into the dataverse table.

     

    Thank you @EricRegnier 

  • Verified answer
    EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Cool, so you're using Dataflows 🙂 Lookups fields are saved as GUID (foreign key of the primary table) in the table, so you'll need to either determine that GUID or better, create an alternate key to define the unique key to represent that record. Once you got your alternate key define on the primary table (the one the lookup refers to) you can map the lookup field more easily. Here's a good blog that explains it in details: https://dynamicscitizendeveloper.com/2020/04/21/how-to-map-a-lookup-field-in-a-power-platform-dataflow/

    Hope this helps!

  • My_connect Profile Picture
    83 on at

     

    Thank you @EricRegnier , still no luck.

    Here is more detailed step by step test ive built

     

    Table02

    this table is successfully loaded with records

    My_connect_2-1614589684463.png

    My_connect_3-1614589700434.png

     

    Table01

    My_connect_0-1614589632401.png

    My_connect_1-1614589661602.png

    On table01 when tried to import >Getdata>SQL>tableafter selecting "create", it just spins for few seconds and closes the window without any result.

     

  • My_connect Profile Picture
    83 on at

    last step

    My_connect_17-1614590285749.png

     

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @My_connect, sorry for my late reply. Instead of going through Import >Getdata>SQL, try via make.powerapps.com>Data>Dataflows and create a new one with SQL Server as the data source. Make sure you connect with an account that doesn't have MFA enabled. At the last step select "Delete rows that no longer exists" option.

    Hope this helps!

  • My_connect Profile Picture
    83 on at

    Finally !!! I've recreated my module and its working.

    Not sure which part was wrong

    Thank you @EricRegnier 

  • mandeo Profile Picture
    2 on at

    Look up columns are not listed in map field while importing csv, Please help

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

Forum hierarchy changes are complete!

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…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard