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

(0) Share

Report

Posted on by My_connect

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (1)

All responses (10)

Answers (1)

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
My_connect 83 on at

Like (0)

Report
Copy link

Link copied!

SQL to Dataverse

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
My_connect 83 on at

Like (0)

Report
Copy link

Link copied!

Once I select tables from SQL and select 'load to existing table' and column mapping is were the problem is,
last step, after I select Create, records do not load to the table.
If i remove lookup fields , im getting the data into the dataverse table.

Thank you @EricRegnier

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
My_connect 83 on at

Like (0)

Report
Copy link

Link copied!

Thank you @EricRegnier , still no luck.
Here is more detailed step by step test ive built

Table02
this table is successfully loaded with records

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

Was this reply helpful? Yes No
My_connect 83 on at

Like (0)

Report
Copy link

Link copied!

last step

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
My_connect 83 on at

Like (0)

Report
Copy link

Link copied!

Finally !!! I've recreated my module and its working.
Not sure which part was wrong
Thank you @EricRegnier

Was this reply helpful? Yes No
mandeo 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No