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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Import into a lookup f...
Microsoft Dynamics CRM (Archived)

Import into a lookup field?

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I am attempting to import date from an 'Accounts_Template_Export' form but I am having some difficulties.

There are around 900 lines on the sheet.
There are around 50 company names
The unique 50 companies above have a 3 letter short parentcode that we would like them to link too.

When I attempt to import this data, the 'parentaccountid' field says that is a lookup and therefore it errors during the import. 
Quite simply, all I want to do is to import the data into the appropriate field without it trying to lookup.  So that each company name has an appropriate 3 letter short code.
What am I doing wrong? 

Help greatly appreciate.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    jlattimer Profile Picture
    jlattimer 24,564 on at

    If you are trying to import text into a lookup field that won't work - the value needs to relate back to another record. Otherwise you'd need to use a different field.

    If you are trying to do a lookup based on the 3 character code, have a look at this blog post - it should help you set up a mapping for a lookup field:

    http://www.powerobjects.com/blog/2011/12/15/importing-lookup-values-using-crm-2011-data-import-wizard/

  • Community Member Profile Picture
    Community Member on at

    Exactly what I am trying to do.

    Thanks!

  • Community Member Profile Picture
    Community Member on at

    Sorry, one new question.

    I have the new field created and imported the data but when I use the search tool, it appears to be searching based on company name and not the 3 letter company code.  Is it possible to adjust the what the search field looks at so that it picks up the 3 letter company code?

  • jlattimer Profile Picture
    jlattimer 24,564 on at

    Look at step 6 in the blog post :)

  • Community Member Profile Picture
    Community Member on at

    Oh I think I understand.

    I will take a closer look.

    Thanks Jason!  about to put another question up!

  • Community Member Profile Picture
    Community Member on at

    Ok, so on reflection and looking again I do not think I explained very well.

    Essentially, I am looking to change the 'quick search' box so that it looks at a different field or multiple fields.  In the example of 'accounts' it appears to be looking up the Company Name rather than the 3 letter code I setup.  Is this customisable?

    I found this which seems to indicate that it may not be possible to have multiple fields searched out of the box : crmbook.powerobjects.com/.../searching-crm

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Varsha deshpande Profile Picture

Varsha deshpande 5

#2
JS-09031509-0 Profile Picture

JS-09031509-0 3

#3
Ciprian P Profile Picture

Ciprian P 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans