My blog on SharePoint, Power Platform and related stuff.
Category: Power Automate
In this blog post I will show how to copy multiple selected Choice column values to another list. 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 choice column called "Choice" that allows multiple selections. … Continue reading Use Power Automate to copy multiple selections from Choice columns between Microsoft Lists
In this blog post I am going to show how it is possible to add and remove users to a SharePoint site using Microsoft Lists and Power Automate. I'll be using the Send an HTTP request to SharePoint action throughout the Flow. "Send an HTTP request to SharePoint" constructs and executes SharePoint REST API calls. … Continue reading Add and remove users to a SharePoint site using Microsoft Lists and Power Automate
In this blog post I will show how to dynamically switch SharePoint Document Libraries based on a string to perform further actions like creating a folder. I've used this pattern for dynamic folder creation where the sheer scale of folders required dedicated Document Libraries based on alphabetic ranges (A-F, G-M, N-T, U-Z). My demo SharePoint … Continue reading Use Power Automate to dynamically switch Document Libraries based on a string
In this blog post I will out line how Power Automate can be used to create a folder in a SharePoint document library and then store the link to the newly created folder inside of Microsoft Lists. I have used this pattern numerous times for business processes where transactional metadata and document storage are required. … Continue reading Use Power Automate to create a folder in SharePoint with link back to Microsoft Lists
I’m sharing my “A 50 minute digital transformation” slide deck from the M365 Saturday Saskatchewan 2020 - Virtual. Thanks to those that attended, I really appreciate it! NY a-50-minute-digital-transformation-m365saskDownload
In this blog post I will show how to use a "button" to "move" an item from one list to another using JSON column formatting. The Create a button to launch a Flow for the selected item JSON code was developed Chris Kent and I have used it to great effect when manual archiving items … Continue reading Use Power Automate to move Microsoft Lists items to another list
In this blog I will show how to take action based on a value in a Microsoft Lists column using Power Automate. A typical use case for this pattern is a change in status value to completed. In my example I will be using the Microsoft Lists Issue Tracker template and when the "Status" column … Continue reading Take action based on value in Microsoft Lists column using Power Automate
In this blog post I will show how to send email reminders for Microsoft Lists items based on a date column using Power Automate. I am using a customized version of the Microsoft Lists Issue Tracker template. See Microsoft Lists: Updated Issue Tracker for more info. Automated email reminders give users time and opportunity to intervene … Continue reading Send email reminders from Microsoft Lists using Power Automate
In my previous blog post I outlined how Power Automate can be used to get responses from Microsoft Forms into Microsoft List. As a follow up to that post, I will show how to add attachments from Forms to Microsoft Lists using Power Automate. See my previous blog post for the form, List and Flow … Continue reading Add attachments from Forms to Microsoft Lists using Power Automate
In this blog post I will outline how to get responses from Microsoft Forms into Microsoft Lists using Power Automate. I am using the Microsoft Lists, Issue tracker template for my examples. I have created a new Forms form that aligns its questions to the Issue tracker list columns. This is how my list column … Continue reading Get responses from Forms to Microsoft Lists using Power Automate
