My blog on SharePoint, Power Platform and related stuff.
Category: Power Automate
In previous posts, we explored using the Send HTTP Request to SharePoint action in Power Automate for tasks like retrieving items with an OData filter query and updating a text column. Now, we'll discuss how to update choice columns in SharePoint Lists using this action. Although the standard Update item action usually works, you'll need … Continue reading Update a CHOICE column using the Send HTTP Request to SharePoint action in Power Automate
In this blog post, we learned how to use the Send HTTP Request to SharePoint action in Power Automate to update an existing single line of text column in a SharePoint list item. This action is powerful and flexible, allowing for various operations on SharePoint data using the REST API.
Did you know that the standard SharePoint actions in Power Automate, such as Get items and Update item, can only manage a maximum of 12 lookup columns? Also, did you know that column types like Image can't be utilized with the Create item and Update item actions? In such cases, the Send HTTP Request to … Continue reading Getting started with the Send HTTP requests to SharePoint using Power Automate
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
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
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
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
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
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
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
Norm Young 