web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Import records with lo...
Customer experience | Sales, Customer Insights,...
Answered

Import records with lookup field from related entity

(0) ShareShare
ReportReport
Posted on by EmmaCRMadmin

Hello, 

I am trying to import new records for a custom entity. On the entity form there is a lookup field to Account. My file I am trying to import looks like this:

pastedimage1595313708999v3.png

So I have added the account number field from the related account entity to be able to connect this new record to an account with account number. We have Accounts with duplicate Account names, which is why we need to use account number to identify the correct account. 

But when I import this file, the new record is created but the Account has not been populated in the lookup field. What am I doing wrong? 

Best Regards, 

Emma

I have the same question (0)
  • LuHao Profile Picture
    LuHao 40,890 on at
    RE: Import records with lookup field from related entity

    Hi partner,

    Did you set the account number field as the reference?

    Please refer to joshimandarblog.wordpress.com/.../

  • EmmaCRMadmin Profile Picture
    EmmaCRMadmin on at
    RE: Import records with lookup field from related entity

    Hello, 

    I just tried it but now the record is not imported at all. I get the following error:

    pastedimage1595315959758v1.png

    I am importing an excel file from my custom entity view or do I need to save it as a CSV file first and then import it?

    /Emma

  • LuHao Profile Picture
    LuHao 40,890 on at
    RE: Import records with lookup field from related entity

    Hi partner,

    Have you tried to populate both Account lookup field and Account Number field in the imported Excel?

  • EmmaCRMadmin Profile Picture
    EmmaCRMadmin on at
    RE: Import records with lookup field from related entity

    yes I tried but when I review the mapping before importing I can only map one of the fields to account entity, when I have selected account for one of them, it is not showing in the list for the other field.

    /Emma

  • Verified answer
    LuHao Profile Picture
    LuHao 40,890 on at
    RE: Import records with lookup field from related entity

    Hi Emma,

    This is my import mapping.

    The Account lookup field maps "Company Name (lookup)", Account Number field maps "Ignore". I imported it successfully with this mapping.

    pastedimage1595325289816v1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 247

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 166 Super User 2025 Season 2

#3
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 164

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans