Power Apps Studio Hacks: Master Search & Replace for Lightning-Fast App Development
When building apps in Microsoft Canvas Power Apps, your formulas and code can quickly grow complex. Searching for keywords or updating variable names across your entire app can be tedious if you do not know the built-in tools. Fortunately, Power Apps Studio offers robust search and find/replace features to make your development workflow much smoother. […]
Connect a Fabric Lakehouse to VS Code in Minutes
Introduction Easily connect your Microsoft Fabric Lakehouse, Warehouse, or SQL Database to VS Code. This gives you the ability to run queries in read-only on Lakehouse’s, or full CRUD operations in Warehouses and SQL Databases from within VS Code. It is as easy as installing a VS Code extension to get started. Fabric Lakehouse I […]
Save Images to Azure Blob Storage via Power Apps and Reference them from a SQL Database
Intro In this article, I demonstrate how to save images from a Power App to Azure Blob Storage and subsequently reference those images from a SQL Server data source. I have developed a Power App designed for product testing, which includes capturing an image as part of the test process. You can also catch the […]
Leverage Copilot Studio and Power Automate to Create an Intelligent Copilot Agent Capable of Reconciling Invoices using a Third-Party AI Service
In today’s fast-paced business environment, managing financial transactions with precision and efficiency is crucial. One of the most challenging tasks in financial management is reconciling invoices with their corresponding purchase orders. This process, often tedious and time-consuming, is prone to human error, leading to discrepancies and delays. Enter the innovative solution of leveraging Copilot Studio […]
Backup an Azure SQL Database to a Lakehouse Using Microsoft Fabric
Intro I’m part of a team who manages an Azure SQL database with over 300 tables and 30 GB of data as part of my role as Power Platform Developer at my current contract. We looked at several different backup options and decided to import the entire database into a different Lakehouse by running a […]
SharePoint List Vacation Time Off Tracker that Removes Weekends and Holidays
After receiving many comments from two previous posts based on Vacation Trackers in SharePoint, one such area of interest is around automating the calculation of time off that includes factoring in weekends and holidays. This is what we are going to tackle in this post. The two previous vacation tracker posts are below:SharePoint Team Vacation […]
Get a Custom Project Tracker Up and Running in Minutes with Dataverse
Intro In this post we are going to look at creating a Project Tracker application in Power Apps using Dataverse and Model-Driven apps. I’ve previously built a project tracker using a SharePoint Lists which is a good tool for this, click here to see that post. It’s even possible to use SharePoint Lists as a […]
Populate a SharePoint Document Library’s Metadata Using JSON and Power Automate
Intro In this blog post, I discuss how to save a PDF document to a SharePoint Document Library, with some of its content previously extracted via AI, and saved in a JSON file, that will populate multiple Document Library columns using Power Automate. Imagine we receive these documents and possibly other files via email from […]
Why Use Microsoft Teams Channels for Project or Program Management in 2024?
Intro If your organization uses Microsoft Teams, you know it’s a great place for individual and group chats, much like any other instant messaging service. Outside of Chats are Teams, which are where people come together to get big things done. If you have a project or program, creating a Team (in Teams) can be […]
How to Setup Microsoft Fabric Capacity for a Power BI Workspace from the Azure Portal
Intro If you are new to setting up Microsoft Fabric then this is the post for you. It walks you through step by step on how to setup Fabric capacity from the Azure Portal and then add that capacity to a Power BI Workspace. From the Azure Portal From within Azure Home, either create a […]