Import data from excel with virtual table lookup

(2) Share

Report

Posted on by djidji

114

Hello, I wanted to import data but I have this error "Unable to resolve search reference":

But this reference exists:

I set up the map like this:

What can I do to make it work, it's a very important feature and we need to import data, for information this error occur with a virtual table, the Item ref (Lookup) comes from an sql server database.

Thank you.

Best regards,

Djilali.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

fyi: Power Up Program - Building model-driven apps with Microsoft Dataverse forum is intended for the Power Up Program course.

Was this reply helpful? Yes No
Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @djidji

I am not able to read those small pictures can you make them bigger.

Also if this is for the Power Up program I want to move it there. Can you let me know if it is .

Thanks

Was this reply helpful? Yes No
djidji 114 on at

Like (0)

Report

Hello Michael,

Thank you for your response, no I changed the category to "Building Power Apps" since it was a mistake from me.

I set the pictures as attachement so you can see them.

The first one show that the import failed because "Unable to resolve search reference"

The second one that the value I try to import exists

The last one show the mapping configuration I took

Thank you,

Best regard,

Djilali.

3..png

2..png

1..png

Was this reply helpful? Yes No
Suggested answer

w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

Hi @djidji

Can you try importing the data via the model-driven app.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hi @djidji

While mapping make sure you will map to the Primary Column of virtual table, else while importing map to the correct column which is available in excel.

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No
djidji 114 on at

Like (0)

Report

Hello,

Thank you for your responses, I tried différent ways of importation, the one I present here is through model-driven app import option.

The map I use I through the primary attribute I have chosen for the virtual table:

And it is correctly mapped from the excel file as the error message concerne the value 0.06.01211 which is present:

Was this reply helpful? Yes No
Suggested answer

w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

This is Solution Explorer.

I was referred to play the model-driven app and import from there.

Here's another import data option in the model-drive app via Excel Online => Copy & Paste

Was this reply helpful? Yes No
djidji 114 on at

Like (0)

Report

Hello,

I have the same result, as I save it start the importation and fails:

There is no dropdown for the virtual table reference available, so I enter and existing value by hand with here for example the Country + Reference Item column:

(for information the first line already exists I have added the second line)

Was this reply helpful? Yes No
w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

Can you export the error rows and post them here?

Was this reply helpful? Yes No
djidji 114 on at

Like (0)

Report

Hello, I made a new import, I attach here the files:

- The xlsx I tried to import

- The xml version of the file I used for the importation (made a convertion from the xlsx)

- The csv file from the export error button (not much information)

- In addition of that I will attach 2 screenshot of the sceen with the lines with an error message (i have reach attachment limit)

For information the values I tried to import exists in the database and I manuelly created them so 261011 and 261010 exists

import bug.xlsx

import bug.xml

import bug xml - ...

Was this reply helpful? Yes No