Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Not possible to import choice and lookup fields (uploading new rows)

Posted on by
Anyone able to provide advice about data import to Dynamics?

Whatever I do I’m never able to import data (upload entirely new rows) together with their lookups or choice fields. It says data selection not found (both if I use name or the code version of the field).

I need to upload first new rows, than export again. Enrich the data and upload again with modified rows. Only this way it works, but there must be better approach.

Does anyone know?


Much appreciated!
  • Suggested answer
    CRM Alpi Profile Picture
    CRM Alpi 28 on at
    Not possible to import choice and lookup fields (uploading new rows)
    Hi there!
    Can you please give us some information about how are you trying to import data? With Excell? With SSISs'?
    I personally use Kingswaysoft, it's free for users if you don't need to schedule SSIS.
    You can manage and import data easyli in my opinion with it. (https://www.kingswaysoft.com/) You have to have installes VS Code in order to create the SSIS and manage the import/export.
     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans