Not sure if this ever happened to you, but it happened to me! I accidentally reset my Development Environment, which is a Sandbox Environment, and lost one of my Unmanaged Solutions, one that I really couldn’t afford to lose. Simple oversight on my part, but what could I do? Thankfully, I still had a copy…
Category: Power Automate
Adventures with Power Platform: Troubleshooting Sharing Apps
Sharing Apps, Flows and Connections can often times be challenging, especially for those new to the Power Platform, so I thought I would take a look at troubleshooting some of the common challenges and resolutions when it comes to sharing these components. We will first look at sharing Power Apps, both Canvas Apps and Model-Driven…
Adventures with Power Platform: Fun with Connections and Connection References
Recently I deployed a solution that contained a Canvas App that grabbed data from a SQL Server using two methods: Deployment seemed to go fine, but I noticed my flow was turned off. I tried to turn it back on and received a nasty error message. Just for kicks and grins I ran the Canvas…
Adventures with Power Automate: Fun with addToTime
I had a recent ask for how to calculate dates in Power Automate, specifically, given a StartDate and Schedule calculate the NextScheduledDate. 📅 The choices for Schedule consisted of Weekly, Monthly, Quarterly, Biannually and Annually. I created two flows, one to do the calculation 🧮, called Date Add Child Flow (Automated), and another, called Date…
Adventures with Power Automate: I See Your Logic App and Raise You a Power Automate Flow!
A peer and friend of mine, Jordan Bean, wrote a blog on How to start/stop Azure Container Apps using Logic Apps – Jordan Bean Dev Blog. His challenge? I have a few demo apps running in Azure Container Apps. Container Apps are a great platform for getting “just enough Kubernetes”. However, when I’m not doing…
Adventures with Power Platform: Power Automate, Excel and Office Scripts! Oh My!
I have been playing around with Office Scripts lately, specifically Office Scripts for Excel. I wanted to create a Power Automate Flow that populated an Excel spreadsheet and then have the pivot table and chart based on the sales data. The spreadsheet consisted of two worksheets, one for car sales data, and another for a…
Adventures with Power Platform – Array Joiner Flow
Most of my life I have been a traditional developer, primarily working with C#. C# has a neat function called String.Join. This function allows the caller to pass in an array of values and a separator character and then returns those results has a concatenated string with each array value separated with the separator character….
Adventures with Power Platform: Default Environment Best Practices
This article is just a list of recommended best practices for the Default environment curated from other Power Platform sites. What makes the Default Environment so special? A single default environment is automatically created by Power Apps for each tenant and shared by all users in that tenant. Users with a standard Power Apps/Power Automate…
Adventures with Power Platform: Security Role Got Me Again! Ugh!
As I was “sharpening my saw” with deploying Power Platform solutions from one environment to another I ran into a “gotcha” that took a couple of days to resolve! Ugh! Let me set the stage. In my Dev environment I have a solution that contains the following: The Sample 1 Item List cloud flows consists…
Adventures with Power Platform: Smartsheet Connector
I was asked to create a sample Canvas App that made use of the Smartsheet Connector. I created a Smartsheet account, and created a sheet call Star Wars Characters. I created two flows, one to get the columns and another to get the rows. Now, I realized I could have done this in a single…