Forum Discussion

Copper Contributor

Sep 23, 2020

Solved

Required Info Columns (Metadata)

Hello Community, We have lots of different document libraries which have not had the Metadata column updated even if it's required, and I would like to try and capture this. Is there a way or...

Document Library

Paul de Jong
Sep 23, 2020
Claire Allen
I am not aware of reports. You may wish to consider the following:
1. Use Views
Add a filter for column is equal to and leave the value blank
2. Use PowerShell
I do not have examples but you iterate through your libraries and detect items without required metadata
3. Use CAML queries (plus CSOM or REST) to filter out items without required metadata.

Options 2 and 3 are quite technical. I am not sure if this is an option. I would first look into using views.

NB:
I am not sure if you can use Search to find empty values. This may also depend on the type of column (single line, date, lookup, managed metadata, ...)
Paul

Paul de Jong

Iron Contributor

Sep 23, 2020

Claire Allen
I am not aware of reports. You may wish to consider the following:
1. Use Views
Add a filter for column is equal to and leave the value blank
2. Use PowerShell
I do not have examples but you iterate through your libraries and detect items without required metadata
3. Use CAML queries (plus CSOM or REST) to filter out items without required metadata.

Options 2 and 3 are quite technical. I am not sure if this is an option. I would first look into using views.

NB:
I am not sure if you can use Search to find empty values. This may also depend on the type of column (single line, date, lookup, managed metadata, ...)
Paul