Bijay Kumar 
As a TypeScript developer, I frequently encounter scenarios where I need to loop through an enum to access its keys or values. In this complete tutorial, I’ll show you multiple methods to iterate over TypeScript enums, with practical examples and best practices that I’ve developed through years of TypeScript development. Enums (enumerations) provide a way … read more…
Last week, while working on creating a SharePoint list and column from Excel flow, I needed to create a lookup column using Power Automate dynamically. At first, it seemed tricky since there’s no direct action for creating lookup columns. However, after some research and testing, I found a way to make it work using the Send an HTTP … read more…
A few days ago, while working on a client project, I needed to create multiple columns in a SharePoint list using Power Automate. Everything went smoothly until I realized the Include Time option was enabled by default when I made a Date and Time column. However, the client specifically wanted only the date without the time. Now, … read more…
Have you noticed that the Title column is mandatory by default when you create a SharePoint list using Power Automate? If you try to set it as non-required by directly adding “Required”: false in the HTTP request while creating the list, you’ll likely run into an error because there’s no direct property for that! But … read more…
To become an expert in TypeScript, you should know how to work with asynchronous code. We can do this using Promises. Promises in TypeScript handle asynchronous operations, making your code more readable and manageable. They represent a value that might not be available yet but will be at some point in the future, allowing your … read more…
A few weeks ago, I developed a Power Automate flow for a client that used SharePoint lists as data sources. There were ten lists, each with more than 30 fields. Due to permission issues, the client had to create all the lists and columns manually. To make this easier, I needed to fetch each SharePoint … read more…
As a developer who has worked with TypeScript for years, I’ve found enums very useful. You should know how to work with TypeScript enums, so I wrote a complete tutorial with practical examples about Enums in TypeScript. By the end of this tutorial, you will become super confident about Enums. What are TypeScript Enums? TypeScript … read more…
In our leave management application, I needed to calculate leave days while ensuring weekends were excluded from the total count. Since weekends shouldn’t be considered leave days, I had to find a way to check if a given date falls on a Saturday or Sunday. After some research, I found an efficient way to identify … read more…
While working on a Create SharePoint Online List and Columns from Excel flow in Power Automate, I needed to create a SharePoint list with a specific internal name. Initially, I attempted to specify the InternalName while creating the list, but I encountered the following error: After checking the SharePoint list properties, I found that there … read more…
I encountered an interesting requirement last week when working with a client. They wanted to automate a process based on the day of the week in Power Automate. Precisely, they needed to trigger different actions depending on whether it was a weekday or a weekend. Luckily, Power Automate provides built-in functions that make it easy … read more…
While working with Power Automate, you often need to check if a column in a SharePoint list equals a specific value before taking further actions. For example, you might want to send an email notification when the Status column in a SharePoint list equals Approved. In this tutorial, I will explain different ways to check … read more…
Recently, while working on a Send Birthday Wishes flow for a client, I needed to retrieve employee birthdays from Office 365 and check if today was someone’s birthday. However, when I ran the flow, it didn’t match anyone’s birthday because none of the employees had a birthday that day. That’s when I thought, why not … read more…
While working with the Power Apps application, we might need to change the theme, such as dark or light mode, which will improve the app’s appearance. We can achieve this with the Power Apps toggle control. In this article, I will explain how to switch light or dark theme color using Power Apps toggle control. … 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
