When a record in Dataverse changes the updated value can represent a state change within a business process that needs to execute further action. Consider the Tasks table. If the Activity Status column value changes to “Completed” then notify the user who submitted the issue. In Power Automate we can support this type of process … Continue reading Take action based on value in a Dataverse column using Power Automate
Category: Power Automate
Error handling in Power Automate using Adaptive Cards for Microsoft Teams
I’ve created enough Power Automate routines to know that they all eventually fail for some reason or other and it’s important to add resiliency to your production Flows where you can. This can include: Using service-accounts for your connections. This removes the impact of account actions like password changes or user deactivations. Adding co-owners to … Continue reading Error handling in Power Automate using Adaptive Cards for Microsoft Teams
Extract multiple lines of text from email using Power Automate
I recently encountered a scenario where I had to extract multiple lines of text from a system generated email using Power Automate. The key to this Flow pattern is the predictability of the system generated message, meaning I can count on line 1 always being line 1 and line 2 always being line 2 etc. … Continue reading Extract multiple lines of text from email using Power Automate
How to get a Power Apps Developer Plan
If you want to get started with Dataverse but do not have a license available get a Power Apps Developer Plan. The Developer Plan gives you Power Apps, Power Automate and Dataverse for non-production use. Learn more at: https://powerapps.microsoft.com/en-us/developerplan/ You have two options for signing up: Get started free, use this choice if are you not using … Continue reading How to get a Power Apps Developer Plan
Export Microsoft List data to Excel
I've previously written about how to import data from Excel into Microsoft Lists. In this post, we will switch things up and export list data into Excel using Power Automate. In our scenario, we will export a subset of the list data into a date-named spreadsheet that is stored in Microsoft Teams daily. Excel Preparation … Continue reading Export Microsoft List data to Excel
Use Power Automate to copy multi-select Person values between Microsoft Lists
In this blog post I will show how to copy multi-select Person values from one list to another. This post is a supplement to: Use Power Automate to move Microsoft Lists items to another list. I am using two lists called Source and Destination. Both lists have a Person column called "Person" that allows multiple selections. Create a new Flow … Continue reading Use Power Automate to copy multi-select Person values between Microsoft Lists
How to create a Teams chat from Microsoft Lists
This blog post is in response to a question posed in the comments section of Microsoft Lists: Updated Issue Tracker. The question is: "Wondering if there is a way of integrating the Teams chat function into the Issue Tracker – so that when someone opens an “issue”; I can chat with them within the context … Continue reading How to create a Teams chat from Microsoft Lists
Power Automate Training Guide: How to Get Your Team Started
This article originally appears on the AvePoint blog as Power Automate Training Guide: How to Get Your Team Started. Power Automate is one of the four hero apps included in the Power Platform (PowerApps, Power Automate, Power BI and Power Virtual Agents) that performs task automation and workflow execution for a variety of user build … Continue reading Power Automate Training Guide: How to Get Your Team Started
Use Adaptive Cards to Update Microsoft Lists from Teams using Power Automate
In this blog post I will show how to update a Choice column in Microsoft Lists using a Microsoft Teams Adaptive Card and Power Automate. If you are following along please be sure to build the List and Flow as described in: Send reminders to Teams from Microsoft Lists using Power Automate and Send an Adaptive … Continue reading Use Adaptive Cards to Update Microsoft Lists from Teams using Power Automate
Send an Adaptive Card to Teams from Microsoft Lists using Power Automate
In my previous blog post I showed how to Send reminders to Teams from Microsoft Lists using Power Automate. In this post we will extend the Flow functionality to include an Adaptive Card based on our Issue Tracker List data. Please see my previous post for the steps required to complete this build. I'm using the … Continue reading Send an Adaptive Card to Teams from Microsoft Lists using Power Automate