web

You’re offline. This is a read only version of the page.

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

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

David Jennaway 14,065 on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

JS-09031509-0 3

#2

AS-17030037-0 2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans