Articles

Learn how to import Excel data directly into SharePoint lists using Power Apps and Power Automate.

If you’ve ever tried to round numbers in Power Automate, you’ve probably discovered something annoying: there’s no built-in Power Automate rounding function. That’s right. You can’t just do: round(3.14159, 2) …because it doesn’t exist. But don’t worry - there are workarounds. And suppose you’re looking to go even deeper with math operations (logarithms, powers, roots, algebra). In that case, there’s a powerful solution using the open-source MathJS library included in thi

In this blog post, we're going to do a high-level overview of Shane’s Vacation Request app. By understanding why he built the app the way he did, it will help to piece everything together. If you would like a step-by-step breakdown, make sure to check out the video below: Understand The Functionality Used First off, and this is important, many of the things you will learn in the video can be applied to all different kinds of apps, which I think gets lost sometimes. So try t

This blog post is about a reliable technique to capture attachments from Forms and add them to a SharePoint list by using Microsoft Power Automate.

Learn how to filter your SharePoint data with oData in Power Automate.

Power Apps and Power Automate Examples from the apps we use to actually run our company. Need ideas? this is your post.

Archiving SharePoint is important for app performance, learn how to do it with Power Automate!

I didn’t know how to build a custom connector using the HTTP step in Power Automate, I wanted to see an example of what someone had already done. Unfortunately, I couldn’t find where someone had bridged that chasm before. Fortunately, I had the encouragement from Shane Young that I could do it, and examples from so many others, that I didn’t give up! I want to encourage you that you can do it, too, and I want to share with you an example of an HTTP connection to ActiveCampai

Learn how to get started with the SharePoint API the easy way via Power Automate. Create sites, lists, and more!

Often to get the most out of our business solutions we create with Power Apps we want to tell the user we need them to do something. The most common way is with an Outlook email or a Teams message. But did you know there is another way? You can send true Mobile style notifications for your Power Apps by creating a quick little flow. These notifications can be sent to your Mobile phone, your Tablet, or even your Smart Watch. Power Apps Send Notificationv2 To send these notific

Are you ready to take your Power Apps and Power Automate projects to the next level? APIs (Application Programming Interfaces) are your secret weapon, seamlessly integrating with various services like SharePoint, Outlook, Dataverse, and more. But if you're new to the world of APIs, fear not! This beginner's guide is designed to demystify APIs and show you how to harness their power in your low-code applications. What is an API? At its core, an API is a structured way to commu

I recently experienced the excitement of using data captured from AI models from AI Builder in a Power Automate cloud flow. To get this kind of functionality in the past I used Power Automate Desktop, which worked, but it felt a little clunky to wire together. Though it’s probably been available for quite a while, I just discovered that by using the capability baked into AI models that are available in AI Builder , you can bypass Power Automate Desktop with a very smooth t

We recently had a problem where a customer needed to know whether a given date fell within the next five working days. After going through some wranglings with Power Automate formulas, we came upon a much simpler solution based on a SharePoint list of workdays. To set things up, we created a simple SharePoint list of two columns: Date (date only) Workday (Y/N) Updating our SharePoint list, we added the calendar days and marked them with a check (signifying 'Y') if on a workda

Learn to upload files to SharePoint using Power Apps and Power Automate

This guide accompanies Shane’s video which walks through how he solved some real-life problems at PowerApps911 by automating reports and rem

Learn how to use a Recurrence flow that gets all of the items from SharePoint that need archived based on their date. Then create a copy of the item and delete the item. Power Automate Archive SharePoint List Item uses an oData query against the date to find old items and passes it to an apply to each loop. Also, the date to archive from is auto calculated using the utcNow expressions and subtracting days from the returned date. Click the video below and get started! Link to

Learn how sending emails via SharePoint gives more control to set the email To's title and have replies go to that user automatically.

Learn how to build a PDF from your SharePoint data by using Power Apps and Power Automate flow. No premium license, no 3rd party connectors, just simple actions put together smartly. Included in this video: Previewing the PDF in Power Apps Dynamic data including images Examples of more complex solutions Common errors and questions The new flow connector in Power Apps Power Apps v2 flow trigger in Power Automate Link to Shane's YouTube channel here . Link to this video on YouT

Get started with an introduction to Power Automate Desktop Flows. Shane explains exactly what it is, how to install it, and how to solve a few automation challenges. Follow along with Shane through this video as you build your first Desktop Flow. Included in this video: What are Power Automate Desktop flows and how to install Building your first flow Browser Automations Outlook and Excel Actions Link to Shane's YouTube channel: https://www.youtube.com/channel/UC7_OGRP8BYvtG