☕ SharePoint Tip #6 — SharePoint Search: making every file findable

Posted on by

Good morning! Here is your 15-minute SharePoint tip for today.

Day 6 | Week 2 — Administration & Security

SharePoint Search: making content discoverable

SharePoint Online has a powerful built-in search engine that indexes the full text of every document, not just filenames. This is one of the biggest advantages over a traditional file server.

How SharePoint search works

When a file is uploaded or edited, SharePoint’s search crawler indexes its content within minutes. The index stores every word inside the document, plus all metadata columns. When a user searches, SharePoint queries this index — not the file system — making results near-instant.

What gets searched

  • Full text of Word, Excel, PowerPoint, PDF, and OneNote files
  • Metadata column values (Status, Department, Author, etc.)
  • File names and titles
  • Page content on SharePoint sites
  • List item data

Key search features to know

KQL (Keyword Query Language) — power users and admins can write precise search queries:

  • author:"John Smith" — files by a specific person
  • filetype:xlsx — only Excel files
  • modified>=2025-01-01 — modified after a date
  • "contract" AND "approved" — must contain both words

Result Sources — define scoped searches. For example, a "Finance Documents" result source that only searches the Finance site. Useful for intranet search boxes on department sites.

Search Schema — maps document metadata to searchable properties. If you add a custom column called "Contract Value," you can make it searchable and refinable in the search panel.

Try it today (5 minutes)

Go to your SharePoint home and use the search bar. Type a word you know exists inside a document (not just the filename). Notice how SharePoint finds content inside files, not just by name. Then try adding filetype:docx after your search term and see how results filter to Word documents only.

As a Product Owner

Poor search experience is one of the top user complaints after a file server migration. The fix is almost always better metadata and content types — not more folders. Invest time in your search schema and result sources early. It pays dividends in user satisfaction.

See you tomorrow at 6:00 AM with Tip #7 — The SharePoint Admin Center tour!