Bijay Kumar 
If you’ve ever opened a SharePoint calendar and stared at a wall of events — all the same color, all blending together — you know how quickly it becomes a headache. Color coding your SharePoint calendar is one of those small changes that makes a surprisingly big difference in how you and your team actually … read more…
A few years ago, I worked with a company where the HR team managed employee policies through email attachments. Every time something changed, a new version went out — and within days, half the team was working off an outdated copy. Nobody knew which version was the real one. This happens everywhere. Marketing teams, finance … read more…
Have you ever tried to save a SharePoint list as a template and hit this error — “The list is too large to save as a template. The size of a template cannot exceed 52428800 bytes“?. I’ve run into this myself, and I know how frustrating it is when you’re just trying to move a list … read more…
If you’ve ever tried to install SharePoint Server 2019 or 2016 on Windows Server and hit a wall with the prerequisites installer, then you might have received the below error: “Microsoft Sync Framework Runtime v1.0 SP1 (x64): download error” I faced this many times. In this tutorial, I’ll walk you through exactly what causes it, … read more…
If you’ve ever tried installing SharePoint on Windows Server and run into the “Windows Server AppFabric: download error” message, you’re not alone. This is one of the most common roadblocks people hit during SharePoint prerequisite installation, and the good news is — it’s totally fixable. I’ve been through this myself, and in this tutorial, I’ll … read more…
If you’ve ever needed to track team events, project deadlines, or company holidays on a SharePoint site, you’ve probably asked yourself — how do I actually add a calendar here? I’ve been there too. The good news is that SharePoint Online gives you more than one way to do it. In this tutorial, I’ll walk … read more…
If you’ve ever built a Power Apps canvas app and wondered how to control what shows up in a combo box based on a button click, you’re in the right place. This is one of those things that trips a lot of people up because the combo box control behaves a little differently from other … read more…
When I was working on an IT Help Desk solution, I needed to retrieve the most recent record using Power Automate and send it to Power Apps. Initially, everything was working fine. I was sorting the list by ID (Descending) to get the latest item. However, during testing, once the list exceeded 5,000 records, the … read more…
As we know, in Power Apps, we cannot technically combine multiple global variables into a single ‘Set’ statement, which often results in a long, repetitive code list. Let’s say, if you have been writing code like this in Power Apps: Set(varName, “John”);Set(varAge, 30);Set(varCity, “New York”);Set(varIsLoggedIn, true); …there’s a better way. You can absolutely set multiple … read more…
If you’ve ever connected a SharePoint list to Power Apps and tried to read a choice column, you’ve probably run into a wall. You write ThisItem.Status expecting to see “Approved” — and instead you get something like {Value: “Approved”}. That’s confusing the first time you see it. The reason is simple: a choice field in SharePoint is not … read more…
If you’ve been hearing “Microsoft 365” thrown around a lot lately and wondering what it actually is — you’re in the right place. I’ll break it all down in plain English, no jargon, no fluff. So, What Exactly Is Microsoft 365? Microsoft 365 is a cloud-based subscription service from Microsoft that gives you access to … read more…
If you’ve ever opened a SharePoint list and felt overwhelmed by a wall of data, you’re not alone. That’s exactly where SharePoint List Views come to the rescue. Think of a view as a lens — it lets you look at the same list data but only shows you what you actually need to see at that … read more…
Do you want to make sure your SharePoint list only shows items relevant to the person viewing it? Whether you’re building a task tracker, an expense submission list, or an HR portal, filtering list views by the current user is one of the most practical things you can do in SharePoint Online. In this tutorial, … read more…
If you’ve ever used a project management tool like Trello or Microsoft Planner, you already know how satisfying it is to see your tasks laid out as cards in columns. That’s exactly what the Board View in SharePoint Online gives you — a clean, visual Kanban-style layout for your list items, right inside SharePoint. In this tutorial, … 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