Answered

Solution Import (lookup fields)

(0) Share

Report

Posted on by Aikuido2

207

Hello, we have imported a specific solution and its tables from one environment to another. After the import, we also transferred the data from all tables using a script.
Now, the lookup columns have been created in several tables, but they are not working. I have also tried adding a new lookup column, but it still does not work.
Do you know why it's not working?

Categories:

Error handling

General topics

Governance & administering

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

pavanmanideep 576 Power Up Champ - 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Aikuido2

The lookup points to a record from the related entity, there could be problem with the related record Guid, hence they were not mapped properly in the Lookup columns.

You can simply do the data migration using tools from XrmToolBox: Data Migration Tool

Hope this helps...

Was this reply helpful? Yes No
Suggested answer

Ram Prakash Duraisamy 5,877 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Aikuido2

Lookup is a cool feature, you need to follow below steps

1. Import Source Table Record

2. Import Destination Table Record with Lookup Associated from Step1

Now it will Work.

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
Aikuido2 207 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey guys, the step with the xrm tool worked perfectly!

Was this reply helpful? Yes No
pavanmanideep 576 Power Up Champ - 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Aikuido2

If any of the reply helped you, please mark it as helpful, it would be great if it helped you.

Thank you.

Was this reply helpful? Yes No