SharePoint lists are a familiar feature for many organizations, especially those leveraging Microsoft 365. They’re incredibly flexible and often find themselves at the center of lightweight applications and data tracking needs. But how far can you stretch their capabilities? Could they serve as a database? Let’s dive into the pros, cons, and practical scenarios to […]
Should I Use SharePoint List as a Database? Read More »
An apostrophe in a data value — a name like O’Reilly, a title like Harry’s Adventures — breaks a SharePoint REST `$filter` query, because OData uses single quotes as the string delimiter and has no way to tell a literal apostrophe apart from the end of the string. The fix is one specific, verified rule:
How to Escape Apostrophes in SharePoint REST Queries Read More »
Command Sets and Application Customizers scope to specific list templates the same way, through `RegistrationType`/`RegistrationId` in `elements.xml`. Field Customizers don’t — they’re registered against a specific column, not a list template, a genuinely different mechanism worth knowing before assuming one pattern covers all three extension types this post touches on. In this post: Scoping a
Rendering SharePoint List Extensions for Specific List Templates Read More »
SharePoint Hub Sites connect multiple sites into one structure — shared navigation, shared branding, and search that spans the hub and everything associated with it. Useful for grouping sites by department, project, or business unit without merging them into one giant site. In this post: What the structure looks like · Key concepts · Setting
Understanding SharePoint Hub Sites: Concepts and Practices Read More »
Managing permissions and group memberships in SharePoint is critical for effective collaboration and security. Automating the process of adding users to SharePoint groups using PowerShell saves time and reduces manual errors compared to adding people one at a time through the browser. Here’s how to do it step by step, with practical use cases and
How to Add Users to SharePoint Group with PowerShell Read More »
Power Automate can create a SharePoint site end-to-end via the SPSiteManager/Create REST endpoint — no PowerShell, no admin center click-through. Useful for project sites, department portals, or onboarding sites that get created the same way every time. In this post: Prerequisites · The flow structure · Step-by-step walkthrough · Testing the flow · Checking before
How to Create a SharePoint Site Using Power Automate Read More »
Worth leading with directly, since it changes which flow pattern is actually worth building: Power Automate’s SharePoint connector has a dedicated Copy file action that copies server-side, without the file’s content ever passing through the flow — a meaningfully better default than the “Get file content” + “Create file” two-step pattern for most straightforward copies.
How to Copy Files from One Site to Another Using Power Automate Read More »
Worth leading with directly, since it changes what this post can actually recommend: `.getAll()` was removed entirely in PnPjs v4, the current major version as of 2026. The replacement isn’t a renamed method — it’s a genuinely different pattern, the same async-iterator (`for await…of`) approach covered from the JavaScript-fundamentals side in Does “for…of” loop wait
PnPJs .getAll() Function to get all list items Explained Read More »
PnP (Patterns and Practices) is the umbrella for several separate tools that speed up SharePoint Framework development — PnPjs for calling SharePoint from code, PnP PowerShell for admin/automation tasks, and a library of reusable React controls for SPFx web parts. This post covers what each actually does, where the real limitations are, and two places
Worth a direct correction before anything else: a `for…of` loop does wait for an `await` inside it — each iteration pauses until the awaited promise resolves before the loop advances to the next one. That’s the opposite of what a stub answer to this question sometimes claims, and it’s easy to get backwards since the
Does “for…of” loop wait for async awaits in JavaScript? Read More »
