KQL (Keyword Query Language) is what SharePoint and Microsoft Search actually parse behind a search box. Keywords, managed properties, and operators that let you ask for exactly what you mean instead of hoping full-text matching gets there on its own. In this post: What KQL actually does · Where you’ll actually write it · Best
Expounding KQL Queries in SharePoint Search Read More »
A Calculated Column derives its value from other columns on the same item, using Excel-like formula syntax, no Power Automate flow or code required. Here are the formulas worth knowing, and the real limitations that decide when a calculated column is the wrong tool. In this post: Common formulas · Real limitations · Creating them
Common Calculated Column Formulas in SharePoint for Quick Implementations Read More »
Important update: the API this post was originally about (SP.Utilities.Utility.SendEmail) was retired by Microsoft on October 31, 2025. If you have code using the raw REST or PnPjs examples further down, it has stopped working. The current, supported way to send email programmatically from SharePoint is Microsoft Graph’s sendMail API. This post now leads with
Send Email in SharePoint with SharePoint REST API and PnPjs : What You Need to Know Read More »
This is genuinely a three-way decision, not two. Most comparisons of Outlook Calendar versus Microsoft Bookings skip the option that actually fits the most common individual use case best: Bookings with Me, a lightweight personal scheduling link built into Outlook that neither requires the full Bookings app nor forces external contacts to email back and
Microsoft Calendar vs Microsoft Bookings : What You Need to Know Before You Choose Read More »
Canvas or Model-Driven is the first real fork in the road for any Power Apps project, and picking wrong means either fighting the tool for the rest of the build or redesigning halfway through. The short version: Canvas gives you a blank screen and full design control; Model-Driven gives you a data model and Microsoft
Power Apps Model-Driven Apps vs Canvas Apps: Which Is Better and When to Use Which? Read More »
Worth a direct correction before anything else: the verification cmdlet that circulates for confirming a site collection app catalog was actually enabled (`Get-SPOSiteCollectionAppCatalogsSite`) doesn’t exist. The real cmdlet is `Get-SPOSiteCollectionAppCatalogs` (no trailing “Site”), and a script built around the wrong name fails with a generic “command not recognized” error that gives no hint the fix
Create SharePoint Site Collection App Catalog: What You Need to Know Read More »
Teams sprawl is a real problem in any tenant that’s been running a while, project Teams that outlived the project, one-off Teams nobody remembers creating, Teams with external guests still sitting in them long after anyone used the channel. Finding which ones are actually dead (not just quiet) is the first step before archiving or
Get All Inactive Microsoft Teams with PowerShell: A Quick Guide Read More »
Microsoft now offers a native, in-preview way to move SharePoint Online and OneDrive content between tenants (for mergers, acquisitions, divestitures, or restructuring) instead of relying on third-party tools like ShareGate or AvePoint. It’s Microsoft-managed and doesn’t need a separate migration platform, but it comes with its own licensing requirements and prep work. In this post:
Cross-Tenant SharePoint Migration (Preview): What You Need to Know Read More »
The Microsoft Teams PowerShell module lets you manage teams, channels, members, and policies in bulk, anything that’s tedious clicking through the admin center one team at a time. In this post: Create a team and add members · Report on all teams · Find inactive teams · Auditing guest access across every team · Archiving
Teams Management with PowerShell : What you need to know Read More »
SharePoint Document Library Sync uses OneDrive for Business as its engine to mirror a document library to your local machine. Files show up in File Explorer or Finder like any other folder, staying two-way synced with the cloud, permissions and versioning intact. In this post: How it works · Real limits worth knowing · Best
Microsoft SharePoint Document Library Sync: What You Need to Know Read More »
