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…
Category: Power Automate
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…
Adventures with Power Platform: Better Practices
This a list of best better practices for the Power Platform and it’s components. if you have others, please include them in the comments and I will add them to the list and give you the credit! Power Platform These are best better practices for working with the Power Platform. Power Apps These are best…
Adventures with Power Apps: View Pull Requests in Azure DevOps in a Canvas App
I had a customer ask if it was possible to create a Canvas App that could display pull requests from Azure DevOps across all projects. Great question! Before I got started, I first had to check to see if there was a connector for Azure DevOps available to the Power Platform. Sure enough! There was…
Adventures with Power Automate:Â Monitor Email Inbox for Messages with No Replies with Sentiment Analysis
I was asked by a customer how they could monitor an email inbox that was used to capture their customer support requests. They wanted to retrieve all the messages in the inbox that had not been replied to and then send an email to the support engineers making them aware of the lack of response….