Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Metadata disappears for indexed columns that are edited to allow multiple responses


Symptoms

When changing an indexed column in a list from a single response to allowing multiple responses, an error occurs:

"The type of this column cannot be changed because it is currently being indexed"

This itself is expected behavior.  However, after doing so, going back to the list will show that any metadata for that column is no longer visible.

↑ Back to the top


Cause

If multiple selections are chosen for a column/field, then the ability to index that column will not be available (by design).

↑ Back to the top


Resolution

Workaround

  1. After reproducing the issue, the metadata in the "Assigned To" column appears to be missing.
  2. Browse to ‘Settings | List Settings’ and click on ‘ Indexed Columns’ 
  3. "Assigned To" is still set to being indexed, so uncheck it and click ‘OK’ 
  4. Go back into the list (note that that the "Assigned To" column still does not contain metadata). 
  5. Then go back to ‘Settings | List Settings ‘ | choose the ‘Assigned To’ column and toggled 'Yes' for "Allow for multiple selections".
  6. Go back to the list and notice the metadata is back for ‘Assigned To’ column.
  7. Now users can make the choice:  Leave this value as a multi-value field or set back to a single value and then add back as an Indexed column.

↑ Back to the top


Keywords: kb, vkball

↑ Back to the top

Article Info
Article ID : 2015261
Revision : 4
Created on : 8/20/2020
Published on : 8/20/2020
Exists online : False
Views : 98