Send a single reminder for multiple items using Lists and Power Automate (UPDATED)

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) →

Use MS Lists and Power Automate to copy files to MS Teams

Use MS Lists and Power Automate to copy files to MS Teams

This blog post is a continuation of the work we did in: Use Microsoft Lists and Power Automate to provision Microsoft TeamsUse MS Lists and Power Automate to provision Private Channels in Teams Use Power Automate to get a MS Teams SharePoint URL Drawing inspiration from a PMO (project management office) team managing multiple projects from a centralized … Continue reading Use MS Lists and Power Automate to copy files to MS Teams →

Use MS Lists and Power Automate to provision Private Channels in Teams

Use MS Lists and Power Automate to provision Private Channels in Teams

In my previous blog post I showed how easy it is to Use Microsoft Lists and Power Automate to provision Microsoft Teams. In this blog post I will show how to extend the previous solution to include the creation of a Microsoft Teams Private Channel. At the time of writing there is no create Private channel … Continue reading Use MS Lists and Power Automate to provision Private Channels in Teams →

Use Microsoft Lists and Power Automate to provision Microsoft Teams

Use Microsoft Lists and Power Automate to provision Microsoft Teams

In this blog post I'll show how easy it is to provision Microsoft Teams teams using Microsoft Lists and Power Automate. Creating a Teams team is super simple from the Teams client, this post is not intended to replace that functionality, rather this has been developed with a PMO (project management office) team managing multiple … Continue reading Use Microsoft Lists and Power Automate to provision Microsoft Teams →

Use Power Automate to copy multiple selections from Choice columns between Microsoft Lists

Use Power Automate to copy multiple selections from Choice columns between Microsoft Lists

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 →

Add and remove users to a SharePoint site using Microsoft Lists and Power Automate

Add and remove users to a SharePoint site using Microsoft Lists and Power Automate

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 →

Use Power Automate to dynamically switch Document Libraries based on a string

Use Power Automate to dynamically switch Document Libraries based on a string

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 →

Use Power Automate to create a folder in SharePoint with link back to Microsoft Lists

Use Power Automate to create a folder in SharePoint with link back to Microsoft Lists

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 →