Answered

importing data problem with look up columns in Model Driven Apps

(0) Share

Report

Posted on by agorkemt

Hello all.

I have made a model driven application with all custome made Dataverse tables etc. Now my internal clients demanding me to populate the tabels with the data. I tried plural times to import from tables, directly in the running app etc. in the format excel (xlsm or CSV) none of them worked. each time I recieved warnings about the mappings and when I matched the source columns with the columns of Dataverse table, I recieved an error which I couldn't understand and couldn't find a solution or a path to resolve it.

So here I am, looking for a solution to the errors I recieved.

This is one of the errors I recieved while I was trying to import data "

"Couldn't resolve the guid for the lookup field: agt_fullname."

and each time I mapped different I recieved different lookup column error indicating about guid problems.

Thanks for helping me out.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (2)

Report

Hi @agorkemt ,

If you have a running model application and you want to load records into a table, the easiest method I have used is to setup a view on the table that contains the columns you want to import and then in the Model App View choose to "Export to Excel". From there you can populate the data into the Excel template and then choose "Import From Excel" to re-import the data.

Note, if you have lookup columns in this method to other tables and those tables have the Primary Name field with duplicate values then it will error that it is unable to resolve since there are multiple and it doesn't know which one to choose.

Do you think this is what you are running into?

Was this reply helpful? Yes No
Verified answer

agorkemt 73 on at

Like (0)

Report

Hey @dpoggemann, thanks for the advice. I think it could work out. A good logic, now i got angry to myself why didn't I think of it before! LOL! i will try it out now.

I think this is my problem;👇
@dpoggemann wrote:
Note, if you have lookup columns in this method to other tables and those tables have the Primary Name field with duplicate values then it will error that it is unable to resolve since there are multiple and it doesn't know which one to choose.

Was this reply helpful? Yes No
Aswath1 42 on at

Like (0)

Report

I have a issue in this. I have a table containing a lookup Column where it is lookuped with the same table where i created the lookup column. but when i load the data i can't successfully upload the data.
what can i do to upload the data.
Note : I have duplicate data in the primary column of that table

Was this reply helpful? Yes No
Aswath1 42 on at

Like (0)

Report

I have a issue in this. I have a table containing a lookup Column where it is lookuped with the same table where i created the lookup column. but when i load the data i can't successfully upload the data.
what can i do to upload the data.
Note : I have duplicate data in the primary column of that table

Was this reply helpful? Yes No