Learn Microsoft SharePoint from our list of Office 365 and SharePoint Online, SharePoint on-premises useful tutorials.
Recently, I tested one of our IT Help Desk solutions that we built using Power Apps, Power Automate, and SharePoint. I wanted to see what happens when the SharePoint list grows beyond 10,000 records. In the past, I never created any manually indexed columns for this list. But this time, I enabled Automatic Indexing. Once … read more…
In SharePoint, the People column is used to assign tasks, show who is responsible, or add team members to a list or library. By default, it displays all users in our organization, which can sometimes be overwhelming and lead to confusion. To solve this, we can limit the People column to only show certain users … read more…
We can publish Sensitivity Labels, which enable you to control who can view and apply them, where they can be used, and what level of protection they provide. For example, you might want your Finance team to apply a “Confidential” label to internal reports, while your Sales team only sees labels relevant to client communication. … read more…
I received a client requirement to retrieve data from a SharePoint list into Power Apps using a Power Automate flow. Although it is possible to fetch SharePoint list data directly in Power Apps, there are scenarios where using a flow is a more effective approach. For example, handling delegation issues when working with large datasets … read more…
When working with document libraries in SharePoint, we need to classify documents by type, for example, Invoice, Contract, Policy, Proposal, etc. The most common way to do this is by creating a choice column called Document Type with predefined values. But what if a user needs to upload a document that doesn’t fit into the … read more…
Recently, one of my clients asked me: “Is there a way we can classify and protect our files in Microsoft 365 so that sensitive documents don’t get shared accidentally?” They want a solution that enables users to collaborate and share files while maintaining the right level of security, such as encryption, watermarks, or access restrictions, … read more…
Recently, one of my clients asked me Is there a way to restrict the download option in SharePoint and OneDrive? They wanted users to view files online, but not be able to download them to their local device. After doing some research and testing, I found that there are actually 4 different ways you can … read more…
When working with the SharePoint Term Store, it’s common to encounter duplicate or similar terms created by different users or as your taxonomy grows. These duplicates make tagging inconsistent and your metadata hard to manage. Thankfully, SharePoint provides an easy way to merge terms into one, helping you keep your metadata clean and organized. In … read more…
I am working on a Document Management System where my client asked me to enable sensitivity labels. By default, sensitivity labels work with supported file types like Word, Excel, and PowerPoint. However, they also wanted to apply labels to PDF files. In this article, I will explain how to enable sensitivity labels for PDFs using … read more…
While working on a document management system, I set up a Power Automate flow to generate a custom ID for every file that gets uploaded. The ID creation worked exactly as expected, but I encountered an issue when attempting to create a document from a template. Power Automate showed an error: In this tutorial, I’ll … read more…
When I work with clients, they usually provide their brand colors to make sure their SharePoint sites reflect their company’s identity. Using these colors, I create custom themes that make the site look professional and match their brand perfectly. The default SharePoint themes don’t always fit every need. Usually, adding custom themes requires running a … read more…
I’m currently working on an intranet portal for a client that requires managing a large number of metadata terms, such as departments, regions, and document types. Manually adding each term one by one would have taken a lot of time. That’s when I used the Import feature in the SharePoint Term Store. SharePoint allows you … read more…
In SharePoint, the Term Store helps maintain consistent metadata across your sites. But users might search using different words for the same term. For example, one user might search for “HR” while another might look for “Human Resources.” To bridge this gap, SharePoint allows you to add synonyms (or ‘Other Labels’) to metadata terms, improving … read more…
Enroll now and get access to all 9 academy courses at no extra cost.
Secure your seat before the batch fills up.
Get the live training plus the complete SPGuides.Academy learning library.
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Learn how to build an invoice management system using SharePoint integration and a repeating table.
📅 2nd September 2026 – 10:00 AM EST | 7:30 PM IST
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App
