News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Import Data through Ex...

Microsoft Dynamics CRM (Archived)

Import Data through Excel successful even with mandatory field missing

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello everyone,

we are doing some tests in CRM Online 2016 and currently we are testing the data import wizard.

We noticed that if in the Excel files we fill the columns it will import the record correctly with each and every field filled, and this is as expected.

But, when we tried to import a record that has some mandatory field left empty, for instance if we import a lead without first and last name, it will be imported instead of beeing rejected.

Is there any customization to take or some setting to set?

Thanks in advance

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

David Jennaway 14,063 on at

Like (2)

Report

RE: Import Data through Excel successful even with mandatory field missing

I think this is just the way it works. CRM has 2 types of mandatory field - 'System Required' and 'Business Required'. Both are applied when entering data via a form, but only 'System Required' is applied for data imports.

Unfortunately you can't see a field to be 'System Required', only to 'Business Required'

You could write a plugin or synchronous workflow to check for the fields and throw an error if they are missing

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans