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
Category: Power Automate
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
Send reminders to Teams from Microsoft Lists using Power Automate
Date based reminders are a great way to add value to any business process, especially when automated. Microsoft Lists has a great email based Set a reminder feature that can be used with no IT support required. Most modern workplace users spend the majority of their time in Microsoft Teams, so to have the reminder … Continue reading Send reminders to Teams from Microsoft Lists using Power Automate
Use Power Automate to create an attribute-based ID in MS Lists
In this blog post I will show how to use Power Automate to create an attribute-based ID in Microsoft Lists. Attribute-based translates to business readable with formatting. This pattern is based on work I did at my previous employer where the List was being used for data imports into a legacy application that required a: … Continue reading Use Power Automate to create an attribute-based ID in MS Lists
Send a single reminder for multiple items using Lists and Power Automate (UPDATED)
Note: The steps in the Create HTML table action have been updated from my original post, on Dec 21, 2020, to address an issue where the Filter array columns were no longer available in Power Automate. This post is inspired by a question I received from a previous blog post where the user wants to … Continue reading Send a single reminder for multiple items using Lists and Power Automate (UPDATED)