Importing from Excel: The lookup reference could not be resolved

(0) Share

Report

Posted on by Giannis Tsak

120

Hello,

We are trying to import quote lines to a specific quote by using an excel template but we can't due to the known error "The lookup reference could not be resolved" in the parent quote column. This quote is a revised one from a previous version meaning it has the same Topic (name) and Quote ID and subsequently we can't use these fields to map on the template and tell the system which quote is the parent.

What's the official solution that is recommended for cases like these and what are possible alternatives that will allow us to import lines to the newly-versioned quote rather than the old one?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Pradeep Rai 5,489 Moderator on at

Like (1)

Report

Hi,

I tried below way and it worked.

1. Create one string field on quote entity and populate the quote GUID into. (for all existing you can write power automate to populate the same field).

2. Now from quote product export the record using newly created string field (i.e. store the quote GUID) and add quote lookup as shown below:

3. Now export the records and make your required changes.

4. Use unified interface to import the same excel file as shown below:

5. Now, during mapping review select the new string field which was created on quote entity as shown below:

Please try and let me know if you face any issues.

Was this reply helpful? Yes No
Giannis Tsak 120 on at

Like (0)

Report

Thank you very much. We indeed had to use the quote guid eventually.

Was this reply helpful? Yes No