Microsoft MVPI build business apps and automations with Power Apps and Power Automate on top of SharePoint Online, and I've worked with SharePoint and the Power Platform for more than six years. My tutorials come from solutions I've built, from galleries and forms to approval flows and Power BI reports.
Before a tutorial is published, Bijay Kumar reviews it, and I test every step in a real Microsoft 365 tenant.
The tutorials readers open most, based on Google Search data.
Sorted by the date each tutorial was last updated.
A sales manager at Contoso asked me for one chart that starts with revenue by region and lets her click down to each state and city. Building three separate charts would have cluttered the page. The answer was to create a hierarchy in Power BI, so one visual can move from Region to State to … Read more >>>
Contoso’s PMO tracked two 2026 projects, a website redesign and a CRM rollout, in a spreadsheet that nobody outside the team opened. They already used Power BI for sales, so I built a Gantt chart in Power BI next to those reports. Now leadership sees every task, owner and percent complete on one timeline. Power … Read more >>>
The Power Automate chunk() function cuts a string or an array into pieces of the length you choose, and returns them as an array. To split an 18-character activation code into blocks of four, put this in a Compose action: It returns [“M7Q2″,”K9X4″,”P8R3″,”T6W1″,”B5”]. The last piece holds whatever is left over, so it can be … Read more >>>
Say you’re automating web orders for a Chicago outdoor store, and every order ID looks like ORD-2026-10-4471-CHI. You need the year, the month, the order number and the store code in separate columns, and the substring() expression pulls each piece out by position. In this tutorial, I’ll show you how to use the power automate … Read more >>>
Megan Bowen manages our Boston, Chicago and Seattle offices, and she wanted an email every time someone logs a facilities request in SharePoint. That took me about five minutes, because the template gallery already has a flow for exactly that job. Power Automate templates are ready-made flows: the trigger, the actions and the connections are … Read more >>>
Have you started working with the Power Automate OData filter query? In this tutorial, I have explained how to use the Power Automate filter query boolean value, especially an example of “Power Automate OData Filter Query Yes/No“. Quick answer: SharePoint stores a Yes/No column as 1 or 0, so in the Get items Filter Query … Read more >>>
Power Automate Get items action retrieves all the item information from a SharePoint list. It also allows you to filter items based on condition while retrieving items from the SharePoint list. In this Power Automate tutorial, I will explain how to get last & first item ID from SharePoint list in Power Automate. Moreover, we … Read more >>>
The Power Automate getPastTime() function returns the current UTC time minus a number of time units, for example getPastTime(7, ‘Day’) for exactly one week ago. It’s the quickest way to build “in the last 7 days” or “older than one year” conditions without first getting the current time. I use it mostly in SharePoint filter … Read more >>>
The Power Automate getFutureTime() function returns the current UTC time plus a number of time units, for example getFutureTime(3, ‘Day’) for exactly three days from now. Use it to set due dates, expiry dates and reminder windows without getting the current time first. In my projects, it fills the Due Date of new Contoso support … Read more >>>
To upload a file from Power Apps to a SharePoint document library, let users pick the file with an Attachments control and send it to a Power Automate flow that runs the SharePoint Create file action. Power Apps can’t write files to a library on its own, because a library isn’t a list with an … Read more >>>
122 copy-paste formulas with real examples, sent straight to your inbox.
Your free Power Automate Expressions Cheat Sheet is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to