SharePoint Online Cookbook

A list of 74 Power Automate recipes for specific SharePoint Online operations. Power Automate examples for SharePoint Online use cases, to save time. This is a work in progress kind of article, I will keep updating it.

– The purpose of this cookbook is to demonstrate how to interact with the SharePoint Online service via Power Automate cloud flows.
– A lot of recipes use either the SharePoint Online REST API or Graph API methods via the Send an HTTP request to SharePoint action.
– All recipes have code snippets & screenshots, which should help you to get started quickly.

Last updated: December 7, 2023

Content Type Gallery

Create a content type (in the gallery)

Document Sets

Create a Document Set with metadata

Fields and Views

Add a Column Validation Formula to a Field
Add a field to a View
Create a Choice type field
Create an additional Lookup type field column
Create a Location type field
Create a Lookup type field
Create a Multi-Value Person type field
Create a View
Remove a field from a View
Update a Filter in a View

Folders and Files

Check a File in as a major version
Check if a Folder exists
Create a Folder
Create a Coloured Folder
Delete a File
Get a File by Id (Guid)
Get OData Type of a Folder
Get UniqueId of a File
Rename a Folder

Lists and List Items

Add a Content Type to a List
Create a List
Create a List item in a folder
Create a Playlist List item
Create a Site Script for an Organisation List Template
Create an Organisation List Template
Get a List by GUID
Get a List by Title
Get Id of a List
Get Organisation List Templates
Restore a version of a List item
Set a Default Content Type on a List
Update Allow management of content types setting
Update Hidden List setting
Update multi-value MMS field in List Item
Update No Crawl List setting

Microsoft Purview

Create a Sensitivity Labels applied to Files report
List items without a Compliance Tag
Set a Compliance Tag for multiple List items
Set a Default Sensitivity Label on a Library
Update Sensitivity Label on a Communication Site
Update Sensitivity Label on a Team Site

Multilingual

Create Translation Pages for All Languages
Create a Translation Page for One Language
Enable Translation setting of a Site
Translate a Site Name
Update Translation Languages of a Site

Navigation

Create Navigation Node with Audience
Get a Navigation Node by Name
Update a Navigation Node
Update Navigation Audience Targeting setting

Pages and content

Add a Text Web Part to a Page
Create a page template
Create a News for Email page template
Get Page by Title
List webparts on a page

Permissions

Create Anyone links Sharing report
Get permissions of a list item
Get Principal Id by LoginName for a Entra Id security Group (or a User)
Remove (unique) permissions of a group on a list

Site Administration

Activate site feature
Get a list item from a Recycle Bin
Get Id of a site
Join a site to a Hub site
Restore item from a Recycle Bin
Update external sharing of a site
Update members can share of a site
Update storage limit of a site

Term Store

Get Term(s) by Label
Get Term Group by Name
Get Term Set by Name

User Profiles

Update multi-value property in a User Profile
Update property in a User Profile

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.