Bijay Kumar 
When you create flows in Power Automate for one of my clients, many processes require decisions based on multiple conditions. For example, you might want to send an email only if a document is approved and its value exceeds $ 50,000 or trigger a different action if an item’s status is either “Pending” or “In … read more…
Many apps require knowing a person’s age, whether it’s for managing employee records, event registrations, or customer details. Power Apps makes it easy to calculate age based on a birthday. In this tutorial, I will discuss how to calculate age in Power Apps, including years, months, and days, with various formulas. So let’s get started! … read more…
Do you want to know how to loop through the properties of an object in TypeScript? In this tutorial, I’ll walk you through several effective methods to iterate over objects in TypeScript with some real examples. From these examples, you will understand how each method works. Understanding Object Structure in TypeScript Before we jump into … read more…
In this tutorial, I will describe how to use the Do Until action in Power Automate and how to configure its key parameters, such as Count and Timeout. While working on a Leave Management App approval process, I needed to wait until multiple conditions were met, such as the leave request being marked as approved … read more…
While I was working on a Power Automate flow for our client that uploads policy documents from SharePoint to a Copilot Studio Agent’s Knowledge base, everything worked well until I uploaded a file that had spaces in the name, like: As soon as I did that, I received the following error in my flow: This … read more…
Our HR team regularly updates policy documents, including leave policies, codes of conduct, and remote work guidelines, and stores them in a SharePoint library. We use a chatbot called Policy Assistant Bot, built in Copilot Studio, to answer employee questions based on these documents. However, every time we update a file, we must manually upload … read more…
Do you need to store and access data in TypeScript using keys, like state abbreviations and their full names, or zip codes and city names? You can achieve this using the TypeScript key value pair. In this tutorial, I will explain different methods to create and use key value pairs in TypeScript with real examples. … read more…
Do you want to add trigger conditions in Power Automate? In this Power Automate tutorial, I will explain everything about “Power Automate trigger conditions“, Power Automate trigger conditions syntax, and various Power Automate trigger conditions examples, etc. Trigger Conditions in Power Automate are like rules that you set for your automated tasks. They make sure … read more…
A while ago, someone asked me how to calculate percentages in Power Apps. It’s a common question, and the good news is that it’s pretty easy to do! In this article, I’ll show you how to calculate percentage in Power Apps canvas app, so you can use them for things like progress bars, scores, or … read more…
Do you want to know how to specify the return type of a function in TypeScript properly? Or wondering why your TypeScript function is throwing type errors even though the logic seems correct? In this tutorial, I’ll walk you through everything you need to know about function return types in TypeScript. I’ll show you how … read more…
When working with SharePoint lists in Power Automate, a common task is to check whether a Person or Group field is empty. Maybe you have an approval process that shouldn’t start until someone is assigned to the task, or you’re sending an email only if a specific person is assigned. Whatever the case, Power Automate … read more…
Yesterday, a Power Apps client asked me if it’s possible to get the details of the last item they submitted in Power Apps using a SharePoint list. The answer is yes! Power Apps has a handy function, LastSubmit(), that lets you quickly retrieve the last item submitted during the current session. In this article, I will … read more…
Have you ever wished that your users could ask a question and receive instant answers from your SharePoint list, such as “What training is available for the IT department?” or “When is the next finance workshop?” Well, now you can make that happen with Copilot Studio. In this tutorial, I will show you how to … read more…
While working on an Expense Claim app in Power Apps, I wanted to add a calculator feature so users can quickly perform basic math operations (such as addition, Subtraction, Multiplication, and Division) without leaving the app. This makes the app more helpful and saves time. In this tutorial, I will explain how to build a … 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