metadata-completeness-auditor

Ask Copilot in SharePoint to run a metadata audit on the library by name, such as "audit the Contracts library". The skill reads the list schema, scans every item against required columns, and saves an HTML gap-report dashboard to a Metadata Reports folder on the site.

The audit classifies each value as missing when it is empty, whitespace-only, an empty multi-value or person field, or a placeholder like N/A, TBD, or a dash. The report lists every item with its completeness percentage and its specific missing fields.

No, the audit is strictly read-only. It never creates columns, writes to items, or changes list settings or views. The only thing it writes is the HTML report file and, if needed, the Metadata Reports folder that holds it.

By default the audit scores columns marked required in the schema, or all user-created content columns if none are required. System fields like ID, Modified, Author, and Title are excluded from scoring because Title is almost always populated and would inflate the result.

Yes, it pages through the entire library rather than stopping at the first page and processes large libraries in batches with running totals. If a read fails or returns partial data, the limitation is recorded plainly in the report instead of filling gaps with assumptions.