Issue: One of my users had a list that had about several hundred items and about 25 columns. She created some views for these items and one was a datasheet view with only about 5 columns. She had created it as a way to modify these columns quickly. However, when she would use this view she noticed something odd: the datasheet view would show duplicates of some of her list items.
When viewing the list in standard view, there was only one of each list item. When we changed to the datasheet view she had created, it would show some items multiple times.
Cause: When we investigated, we found that some of her columns were columns with the data type set to Person or Group. The number of people chosen for the list item directly correlated to the number of items that displayed in the datasheet view! However, when we added the person column to the datasheet view, the problem went away! She really didn’t want that column showing, so we had to figure out what was causing it. We examined her settings on the columns:
• It was a column with a type of Person or Group
• It was required
• It allowed multiple selections
We removed the required field for that column, and the duplicates disappeared! We removed the ability for multiple selections and the duplicates disappeared this way as well.
It was only that combination of having a required person column allowing multiple entries that was not showing in the datasheet view that was causing the problem.
Fix: Unfortunately for our user, her options were to either display the column in datasheet view, disallow multiple entries for the person column or make it a non-required field.
No comments:
Post a Comment