ERROR: Columns that require data are not included in this view

Question

So we have a Document Library, and inside the Document Library, we have Document Sets, and inside the Document Sets, we have Documents. No surprise so far, I know. However, when I go into Datasheet View showing Document-level metadata and try to change the value in a field, I get the following error:

"Columns that require data are not included in this view. If you want to edit rows that are missing data in these columns, or add new rows, you must first add the required columns to the view."

However, we have confirmed that all document-level required fields are included in this view. In addition, we've tried everything explained in a ton of online resources, of which apparently I don't have enough reputation points to add here.

...But to make a long story short, absolutely nothing has worked. Any advice about where else we should even start would be extremely helpful. We're pretty much pulling our hair out over here. :(

~CR

Answer 1

I just went through something similar but we were not using document sets.

I made all the columns for the content type I was using optional but kept getting the same error message when I tried to edit a row in datasheet view.

To fix the issue I set "Allow management of content types?" to "No" and saw that a number of columns on the document library were required. I set them all to optional and it worked.

My speculation is that SharePoint only recognizes content types with full fidelity in the standard form view but uses more of the document library attributes / settings in the datasheet view. I haven't seen this documented anywhere but it seems consistent with other behavior that I've seen.

Answer 2

This is how I've solved it in my case.

What is wrong

Built-in field "Name" (aka FileLeafRef) was a required field in SharePoint lists. This field should only be required in the Document libraries. How it happened I have no idea.

How to fix it on a single list

• Navigate to the list's settings
• Click on any columns in the list.
• Modify the URL. Remove whatever goes after &Field= and replace it with &Field=FileLeafRef Example: http://portal.com/_layouts/FldEditEx.aspx?List=%7B55BA2134%2D32B1%2D42BE%2D9A01%2D52D1FE1458D0%7D&Field=FileLeafRef
• Set "Require that this column contains information" to "No"

Answer 3

This occurs when your VIEW is missing one or more mandatory fields from the original LIST.

1) This is a sample LIST. Note we have 2 mandatory fields:

2) This is a view with the 2 mandatory fields, we can add records with no errors:

3) This is a view with only 1 of the mandatory fields:

4) When you try to add a new record in Datsheet View mode, the error appears, as you don't provide the mandatory value to the field MyMandatory2:

The error does not occurs in Standard View because when you add/edit a record, ALL list fields are presented, not only the view fields.

CONCLUSION: You need to put ALL mandatory fields of your list into your view to stop the error.

OR you can review & change the mandatory fields in your list.