Bijay Kumar 
As a Power Apps app developer, you will often be required to use the count() function in Power Apps. So, you should know how to use the Power Apps count() function. In this tutorial, I will explain how to use count() in Power Apps with some real examples. Many related count functions are available, such … read more…
Recently, we received a requirement from the client that he needs to create a SharePoint site as a template at the organizational level so that users can create a SharePoint site from that custom template and also apply this custom template to an existing SharePoint site. In this tutorial, I will explain how we can … read more…
I encountered an interesting requirement while working with a client a few days ago. They wanted an automated birthday reminder system in Power Automate. The goal was simple: After receiving this requirement, I explored different ways to implement it. I found two approaches to getting employees’ birth dates: Both methods achieve the same goal of … read more…
Have you ever needed to check if an attachment exists before taking action in Power Automate? I faced this requirement in an Expense Management System product, where I had to ensure receipts were attached before processing expense claims. In this tutorial, I will show you how to check if attachment exists using Power Automate in three … read more…
Data Analysis Expressions (DAX) is the formula language that you can use to do calculations in Microsoft Power BI. It helps transform raw data into meaningful insights through a collection of functions, operators, and constants. DAX contains over 250 functions designed specifically for business intelligence, allowing users to create complex calculations that would be difficult … read more…
A few weeks ago, I encountered an interesting scenario while working with strings in Power Automate. That’s when I thought sharing how to handle different string conditions in Power Automate would be helpful. In this article, we’ll explore Power Automate Condition If String, such as checking if a string is empty, verifying if it contains … read more…
In this tutorial, I will explain how to use the length() function in Power Automate to check the number of characters in a string or the number of items in an array. Additionally, I will cover scenarios such as checking if a string length is greater than a certain value before triggering an action, handling … read more…
While developing a Power Apps application, I encountered a new issue: We needed to make a text hyperlink that should open in a new tab. Let’s discuss the requirements below intensely. In this tutorial, I will explain the best way to make a text input as hyperlink in Power Apps using a simple scenario. Refer … read more…
One of my subscribers reached out a few days ago with an interesting query. They were working on a Power Automate flow and needed to check if the Body of a response or action was empty before proceeding. This is a common scenario, especially when dealing with APIs and HTTP requests where data may or … read more…
While working with SharePoint along with Power Apps or Power Automate, we may often require the SharePoint site ID. In my case, I removed some of the environment variables in the Power Apps solution, and then I got an error that contained an ID with the SharePoint connection. At that point, I was required to … read more…
A few weeks ago, they had a specific requirement while working on a Project Status Tracker for a client. Whenever the Status column changed in a SharePoint list, they wanted to send an email notification. But they needed to know the previous status before the change. After researching, we could achieve this using the Get changes for an … read more…
While working on a Create List with Different Types of Columns flow in Power Automate, I encountered a situation where I needed to check if a SharePoint list with a specific display name already existed. If the list doesn’t exist, the flow should create one. But if it already exists, the flow should send a notification instead … read more…
Last week, while working on a flow, I encountered a situation where I needed to check if a filename contained a specific keyword before proceeding with further actions. This is a common requirement when managing documents in SharePoint, OneDrive, or email attachments. In this tutorial, I will show you how to use Power Automate to … read more…
While working on a Leave Management application, we needed a Request ID that had to be unique every time. Initially, I considered using the rand() function, but I realized there was still a chance of getting duplicate values. After some research, I found that using a GUID (Globally Unique Identifier) is a much more reliable … 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