Power Automate: Multi-select columns in SharePoint
by Power Automate and SharePoint work excellently, but I see many people with questions regarding how to fetch multi-select columns in SharePoint. Especially the “Person” columns …
Category: SharePoint
SharePoint is a platform that evolved a lot in the past few years. It provides a simple and straightforward interface that allows you to do advanced operations quite efficiently. I write these articles with step-by-step tutorials to teach you how to build your sites in SharePoint. Once you understand these concepts, you will be able to, develop, and provide rich collaboration platforms with not a lot of work. These can give document version control, document collaboration, and even store organized data. If you’re a pro, I’m sure you can find something useful and learn something.
Power Automate: Sync Excel to a SharePoint list
Syncing is one of the most complex challenges in all platforms. We all suffered from issues where our files don’t sync appropriately on OneDrive, or …
Microsoft / Office 365 / Power Automate / Power Automate Trigger Reference / Power Platform / Reference / SharePoint
Power Automate: SharePoint – When a file is created in a folder Trigger
Automating file management is an excellent way to save time, especially if you have many. There are many advantages to knowing when a file is …
SharePoint: Lower Function
One of the trickiest things is to keep data consistent, especially if it’s inserted by the users. Each person has their way of providing data, …
Microsoft / Power Automate / Power Automate Action Reference / Power Platform / Reference / SharePoint
Power Automate: SharePoint – Get File Metadata Action
File metadata is boring but can be incredibly useful. The SharePoint “Get File Metadata” action enables you to get information like the file’s path, size, …
SharePoint: Import a new Excel automatically to a list
I got this question from a reader, and it’s an interesting one. “When an Excel file is created in a document library, import all its …
SharePoint: AVERAGE function
The average function draws a lot from Excel, where we can have one or more columns (or cells in Excel) and return the average of …
Power Automate: Send an HTTP request to SharePoint Action
Power Automate has an amazing set of actions for SharePoint, but none is more versatile than the “Send an HTTP request to SharePoint” action. With …
SharePoint: Hour Function
The “hour function” is part of a suite of functions that deal with dates. It returns the part of the time; for example, 12:30 will …
Power Automate: SharePoint Get Items Action
SharePoint is an amazing place to store information, and lists are the most useful way to organize the information. With the release of Microsoft Lists, …