My blog on SharePoint, Power Platform and related stuff.
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
Check out this related flow pattern on the Power Platform Samples repository: https://github.com/pnp/powerautomate-samples/tree/main/samples/create-folder-with-link-back-to-list 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 … Continue reading Use Power Automate to create a folder in SharePoint with link back to Microsoft Lists (UPDATED)
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
This article originally appears on the AvePoint blog as SharePoint vs. Microsoft Teams: Why They’re Better Together. Change. There is so much change in the Microsoft 365 platform that users can feel lost in a sea of like-named and functioning apps. Take OneDrive and OneNote for example. Or how about a Team site and Teams? … Continue reading SharePoint vs. Microsoft Teams: Why They’re Better Together
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
Note: The "Get file content using path" and "Apply to each - Add attachment" actions have updated from my original post to correct an issue where the content from multiple attachments was being duplicated. I added a check "Condition" on the length of the Associated files from MS Forms to ensure that attempts to add … Continue reading Add attachments from Forms to Microsoft Lists using Power Automate (UPDATED)
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
Norm Young 