Power Automate Cookbook

Ready-to-use templates for common automation tasks. Download and import directly into your Power Automate flows.

Download & Import

Each template is ready to download and import directly into Power Automate.

Well Documented

Each template includes documentation on how to use and customize it.

Tested & Working

All templates are tested and verified to work with the latest Power Automate version.

Free to Use

All templates are free to use and share with your team.

Go to top

SharePoint

When a file is created, import it to a list

Automatically import file metadata to a SharePoint list when new files are created.

Find all files of a type in a folder

Search and list all files matching a specific type within a SharePoint folder.

Check if Document Library exists

Verify whether a SharePoint document library exists before performing operations.

Synchronize Excel to SharePoint list

Keep a SharePoint list in sync with an Excel spreadsheet.

Get changes on SharePoint list

Track and retrieve changes made to items in a SharePoint list.

Fetch multi-select columns in SharePoint

Properly retrieve and parse multi-select choice columns from SharePoint.

Multi-select form to SharePoint

Submit multi-select form data to SharePoint lists correctly.

Forms to SharePoint attachments

Handle form attachments and save them to SharePoint.

CSV & Excel

Parse CSV file

Read and parse CSV file contents into usable data for your flows.

Parse CSV from OneDrive

Read CSV files directly from OneDrive and process them.

Get Excel rows based on path

Retrieve rows from Excel files using dynamic file paths.

Convert Excel number to date

Transform Excel serial date numbers into proper date formats.

Email & Calendar

Email arrives during working hours

Process emails only when they arrive during business hours.

Move emails back to inbox at start of day

Automatically move processed emails back to inbox each morning.

When new email arrives, add to Planner

Create Planner tasks automatically from incoming emails.

Add attachments to email dynamically

Dynamically attach multiple files to outgoing emails.

Generate an ICS calendar file

Create ICS calendar event files for invitations.

Create buffer after meeting

Automatically add buffer time blocks after calendar meetings.

Planner

Add attachments to Planner from Teams

Transfer file attachments from Teams to Planner tasks.

Add Planner checklist items dynamically

Create checklist items in Planner tasks from dynamic data.

HTML & Parsing

Get HTML tag value

Extract values from specific HTML tags in content.

Convert HTML table to JSON

Transform HTML tables into JSON data structures.

HTTP & API

Find UTM elements (Request)

Parse and extract UTM parameters from URLs in HTTP requests.

Find UTM elements

Extract and process UTM tracking parameters from URLs.

Call flow with GET request

Trigger another Power Automate flow using HTTP GET request.

Error Handling

Try/Catch/Finally pattern

Implement proper error handling with try/catch/finally structure.

Utilities

Sort a numeric array

Sort arrays containing numeric values in ascending or descending order.

Scrum random talk order

Generate random speaking order for daily standup meetings.

Get next X business days

Calculate dates that are X business days in the future.

Convert timestamp to date

Transform Unix timestamps into readable date formats.

How to unzip a file

Extract contents from ZIP archives in your flows.

Multiple conditions in Filter Array

Apply multiple filter conditions to arrays in Power Automate.