Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.

Power Automate: Format Dates to ISO 8601 [3 Real-World Scenarios + Fixes]

April 3, 2026 by Bijay Kumar

Format a SharePoint List Date to ISO 8601 in Power automate

You’ve built a Power Automate flow that looks perfect — until it hits an API, an Excel table, or a SharePoint connector and throws a cryptic error about date formats. Nine times out of ten, the problem is ISO 8601. I’ve run into this more times than I can count, and it’s almost always one … Read more >>>

Create a SharePoint Folder in Power Automate [3 Methods, Including Duplicate-Check]

April 3, 2026April 3, 2026 by Bijay Kumar

SharePoint Action Create Folder in Power Automate

If you’ve ever had a Power Automate flow fail because the target folder didn’t exist yet — or worse, accidentally created duplicate folders by running the same flow twice — you’re in exactly the right place. In this tutorial, I’m going to walk you through three practical ways to create a folder in a SharePoint Document … Read more >>>

Power Automate skip() Function: Syntax, Real Examples & Common Mistakes

April 3, 2026March 31, 2026 by Bijay Kumar

Power Automate Skip the First Item in an Array

If you’ve ever had a Power Automate flow process a header row, a draft record, or a stale entry you didn’t need, the skip() function is exactly what you’re looking for. I use skip() all the time when working with SharePoint lists and Excel tables. It’s one of those simple functions that saves you from writing extra conditions or … Read more >>>

Create a QR Code in Power Apps [3 Methods That Actually Work]

April 1, 2026March 27, 2026 by Bijay Kumar

If you’ve ever wanted to generate a QR code directly inside a Power Apps canvas app — maybe for an inventory system, an event check-in, or just to share a link — you’re in the right place. In this tutorial, I’ll walk you through three practical methods to create QR codes in Power Apps, from … Read more >>>

Power Automate: Get Attachments From a SharePoint List Item and Send by Email

March 31, 2026March 25, 2026 by Bijay Kumar

If you’ve ever needed to pull file attachments out of a SharePoint list item and email them automatically, this tutorial is for you. I’ll walk you through building the entire flow from scratch — step by step — and I’ll also cover the variations and errors that trip people up most often. I’ve worked with … Read more >>>

How to Initialize an Object Variable in Power Automate [With Real Examples]

June 28, 2026March 24, 2026 by Bijay Kumar

If your Power Automate flow needs to carry structured data — like a user record, SharePoint item details, or an API response — an Object variable is the right tool for the job. Unlike a String or Integer variable that holds a single value, an Object variable holds a full JSON structure with multiple key-value pairs, so … Read more >>>

2 Simple Ways to Count Rows in a SharePoint List Using Power Automate

March 24, 2026March 23, 2026 by Bijay Kumar

How to Count Rows in a SharePoint List Using Power Automate

You’ve built a SharePoint list, it’s grown to a few hundred rows, and now you need to pull that row count inside a Power Automate flow — maybe to send a daily summary, trigger logic based on how many items exist, or just track how full a list is getting. The good news: there are … Read more >>>

Last Function in Power Apps [With Real Examples]

March 25, 2026March 23, 2026 by Bijay Kumar

Get the Last Record from a Power Apps Collection

If you’ve ever needed to grab the most recent entry from a SharePoint list, pull the last item a user submitted, or show the bottom few records in a gallery, the Last function in Power Apps is exactly what you need. In this tutorial, I’m going to walk you through everything: what the function does, how the … Read more >>>

Power Apps Concatenate Two Fields: 4 Easy Methods

March 23, 2026March 21, 2026 by Bijay Kumar

If you’ve built even a basic Power Apps form that pulls data from a SharePoint list, you’ve probably run into this situation — you have a First Name field and a Last Name field, and you want to display them together as a full name somewhere on the screen. Or maybe you need to combine a city and a … Read more >>>

How to Convert HTML to Text in Power Automate [Step-by-Step]

March 23, 2026March 20, 2026 by Bijay Kumar

Convert an HTML File to Plain Text and Email It in Power Automate

If you’re seeing messy HTML tags showing up in your Power Automate emails, Teams messages, or SharePoint list items — you’re not alone. This is one of the most common frustrations when working with flows that pull content from SharePoint Rich Text columns, Outlook email bodies, or Dataverse records. The good news: Power Automate has … Read more >>>