An ever-growing Power Automate Actions
My way of explaining each function with as much detail as I can. You'll find suggestions, best practices, things to avoid, and limitations.
Last updated
I'll include all my experiences (good and bad) working with the functions.
I want people to use it and share it. So I won't put any restriction on it on this reference.
Please contribute! The better I can make it, the better it will be for everyone.
I learn from lots of places, so some things may be found elsewhere.
Microsoft Forms (1)
Go to topMicrosoft Planner (8)
Planner - Create a task
Creates a Planner task: group, plan, title, dates, assignments, and labels.
ViewPlanner - Get a task
Returns a Planner task: title, dates, assignments, tags, and completion percentage.
ViewPlanner - Get task details
Returns a Planner task's description, references, and checklist items.
ViewPlanner - List Buckets
Returns all buckets in a Planner plan with names, IDs, and order hints.
ViewPlanner - List Tasks
Returns all tasks from a Planner plan as an array.
ViewPlanner - Update a task (V2)
Updates a Planner task with Percent Complete, Bucket Id, and 25 category fields.
ViewPlanner - Update a task
Modifies a Planner task: title, dates, progress, and assignments.
ViewPlanner - Update task details
Modifies a Planner task's description, references, and checklist items.
ViewOffice 365 Excel (6)
Office 365 Excel - Add a key column to a table
Adds a key column to an Excel table so other Excel actions can reference rows.
ViewOffice 365 Excel - Delete Row
Removes a row from an Excel table by key column value.
ViewOffice 365 Excel - Get a Row
Returns a single Excel row by key column value.
ViewOffice 365 Excel - List rows present in a table
Returns all rows from an Excel table. Requires table-formatted data.
ViewOffice 365 Excel - Update a Row
Modifies an Excel row by key column. Works on SharePoint, Teams, and OneDrive.
ViewOffice 365 Excel - Update a row
Modifies an Excel row by key column. Requires table-formatted data.
ViewOffice 365 Outlook (5)
Move Email
Moves an Outlook email to a folder.
ViewOffice 365 Outlook - Delete email
Deletes an Outlook email by Message ID.
ViewOffice 365 Outlook - Forward an email
Forwards an Outlook email with optional comments.
ViewOffice 365 Outlook - Get email
Returns an Outlook email by Message ID.
ViewOffice 365 Outlook - Outlook Flag email
Flags an Outlook email by Message ID.
ViewOneDrive for Business (5)
OneDrive For Business - Delete file
Deletes a OneDrive for Business file by file ID.
ViewOneDrive for Business - Create file
Creates a file in OneDrive for Business.
ViewOneDrive for Business - Get File Content
Returns a OneDrive file by file ID.
ViewOneDrive for Business - Get File Content Using Path
Returns a OneDrive file by path.
ViewOneDrive for Business - Get file metadata using path
Returns OneDrive file info without downloading the content.
ViewPower Automate (24)
Filter Array
Returns items from an array that match a condition. Supports AND/OR logic.
ViewParse JSON
Turns raw JSON into typed dynamic content. Schema-driven.
ViewAppend to array variable
Adds an item to an array variable. Accepts mixed data types.
ViewAppend to string variable
Adds text to an existing string variable.
ViewApply to each
Loops through an array. Use item() to reference each element.
ViewCompose
Stores any data, expression, or computed value for reuse downstream.
ViewCondition
Routes the Flow into a true or false branch based on a comparison.
ViewConvert Time Zone
Converts a timestamp from one timezone to another.
ViewDecrement Variable
Subtracts a value from an Integer or Float variable.
ViewDelay
Pauses the Flow for a fixed duration.
ViewDo Until
Loops until a condition is met. Always runs at least once; has iteration limits.
ViewFormat Number
Formats a number as currency, percentage, or custom pattern with locale support.
ViewGet My Profile
Returns your Office 365 profile: department, job title, contact info.
ViewHTML to Text
Strips HTML tags and returns raw text.
ViewIncrement Variable
Adds a value to an Integer or Float variable.
ViewInitialize variable
Declares a variable. Required first step before any other variable action.
ViewRespond to a PowerApp or flow
Returns data from a child Flow to its parent Flow or Power App caller.
ViewRun a Child Flow
Calls a reusable child Flow.
ViewScope
Groups related actions into a logical block.
ViewSelect
Reshapes an array without a loop. Faster than Apply to each.
ViewSend an email notification
Sends an email without using your personal mailbox.
ViewSet variable
Assigns a value to an existing variable. Strict type enforcement.
ViewSwitch
Routes the Flow into multiple branches based on a single value. 25-case limit.
ViewTerminate
Stops the Flow with Succeeded, Failed, or Cancelled status.
View