Power Automate Tutorials Hub – Learn Power Automate Step By Step

On this page, I am bringing together all Power Automate tutorials so you can learn systematically while still jumping directly to the pattern you need. To keep it easy to skim, all 200+ tutorials are grouped into 9 major sections: fundamentals and expressions, SharePoint automation, Dataverse and data integration, approvals and notifications, Outlook/Teams/Planner automation, files/PDF/Excel/Word automation, arrays/JSON/XML and advanced expressions, Power Automate Desktop and RPA, and real‑world business scenarios and Copilot.

What is Power Automate, and why use it?

Microsoft Power Automate (formerly Microsoft Flow) is a low‑code automation platform that lets you connect your apps, services, and data to build automated workflows. With Power Automate, you can replace manual, repetitive tasks with flows that run automatically based on triggers and conditions.

Organizations use Power Automate to send notifications, move data between systems, generate documents, manage approvals, synchronize SharePoint and Dataverse, and connect Microsoft 365 with external services. Instead of writing full‑blown code, you design flows using connectors, actions, and expressions that are easy to maintain and share.

Who is this Power Automate tutorials hub for?

This Power Automate tutorials hub is for beginners, citizen developers, and experienced consultants who want practical, copy‑paste‑ready flow patterns. If you are starting out, you can treat this page as a guided learning path.

If you have already built flows, you can use this hub as a reference whenever you need to solve a specific problem—like approvals with custom responses, generating PDFs from SharePoint, working with CSV or XML, manipulating arrays, or handling date and time expressions.

How to follow this Power Automate learning path

If you are a beginner, start with Power Automate fundamentals and core expressions to understand flows, triggers, conditions, and basic functions. Then move to SharePoint automation, Dataverse, and data integration to automate your main data sources. After that, explore Approvals and notifications and Outlook, Teams, and Planner automation so your flows engage users and support collaboration.

Once you are comfortable, dive into Files, PDFs, Excel, and Word automation and Arrays, JSON, XML, and advanced expressions to handle complex data. Finally, explore Power Automate Desktop and RPA and Real‑world business scenarios and Copilot to build full automation solutions end‑to‑end.

1. Power Automate fundamentals and core expressions

This section covers the basics you need in almost every flow: if conditions, trigger conditions, multiple conditions, variables, type conversions, string/number/date formatting, and core expression patterns.

Use this section to master the core building blocks you will use in almost every flow: conditions, trigger conditions, loops, variables, string and number conversions, date/time formatting, and common error‑handling patterns.

• Learn basic condition logic with Power Automate If condition
• Combine multiple checks using Power Automate multiple conditions
• Control when flows run with Power Automate trigger conditions
• Loop until a condition is met using Power Automate Do Until loop
• Run actions in parallel branches with Power Automate parallel branch
• Initialize variables correctly with Power Automate initialize variable
• Increment counters and indexes using Power Automate increment variable
• Understand conversions and types via Power Automate conversion of string
• Split strings into arrays using Split a string into an array in Power Automate
• Get only the first part of a split value with Power Automate split string and get first value
• Convert a string to an array using Convert a string to an array in Power Automate
• Append many values at once using Append multiple values to an array in Power Automate
• Append a string into an array via Append a string to an array in Power Automate
• Count items inside an array using Count items in an array using Power Automate
• Filter array values with conditions using Power Automate filter array action
• Check if an array is empty via Check if array is empty in Power Automate
• Check if an array contains a value with Check if an array contains value using Power Automate
• Convert an integer to an array using Convert an integer to an array in Power Automate
• Convert an array back to a string via Convert an array to a string using Power Automate
• Replace characters in text using Replace characters in Power Automate
• Remove unwanted characters with Remove characters from string in Power Automate
• Extract specific parts of text using Extract substring from text using Power Automate Desktop
• Convert string to integer using Convert string to integer in Power Automate
• Convert string to decimal/float via:
  • Convert string to decimal in Power Automate
  • Convert float to integer in Power Automate
• Convert a number to rounding up/down with Convert a number to rounding up or down in Power Automate
• Format a number as currency using Format a number as currency in Power Automate
• Format numbers to percentage via Format number to percentage in Power Automate
• Format numbers with thousand separator using Format number thousand separator in Power Automate
• Format numbers without decimals via Format number without decimal in Power Automate
• Format numbers to decimal places using Format numbers to decimal places using Power Automate
• Format numbers with leading zeros via Format numbers with leading zeros using Power Automate
• Convert percentage to whole number using Convert percentage to whole number in Power Automate
• Convert decimal to whole number via Convert decimal to whole number in Power Automate
• Convert a number to hexadecimal using Convert a number to hexadecimal in Power Automate
• Convert number to date via Convert number to date in Power Automate
• Convert value to string using Convert value to string in Power Automate
• See all formatting options in Power Automate number format guide
• Work with date and time formatting via Power Automate formatDateTime function
• Convert time zones correctly using Power Automate convert time zone
• Add days to dates via Power Automate add days to date
• Check if a date is a weekend using Check if the date is weekend in Power Automate
• Work with day of week using DayOfWeek function in Power Automate
• Convert string to date for SharePoint using Convert string to date for SharePoint list using Power Automate
• Handle ISO 8601 issues with The datetime string must match ISO 8601 format error in Power Automate
• Convert string to GUID using Convert string to GUID in Power Automate
• Generate new GUIDs via Generate new GUID in Power Automate
• Convert string to object using Convert string to object in Power Automate
• Check if SharePoint column equals a value using Check if SharePoint list column equals in Power Automate
• Check if a field is blank via Check if field is blank in Power Automate
• Check if a person field is empty using Power Automate check if person field empty
• Check if the body is empty with Check if the body is empty in Power Automate
• Use length in conditions via Power Automate If length expression
• Build string conditions using Power Automate condition if string
• Check if filename contains specific text using Check if the filename contains in Power Automate
• Check if a SharePoint list is empty via Check if SharePoint list is empty in Power Automate
• Check if SharePoint list already exists using Check if SharePoint list already exists in Power Automate
• Check if a SharePoint site already exists via Check if SharePoint site already exists in Power Automate
• Check if a column changed using Check if the column is changed in Power Automate
• Handle deep nesting issues with Power Automate – which exceeds the maximum nesting limit of 8
• Implement try/catch patterns via Power Automate exception handling using try catch

2. SharePoint automation with Power Automate

Use this section when your flows work with SharePoint lists and libraries: creating sites and lists, managing columns and content types, reading/writing list items, using REST API, permissions, and document operations.

Create sites, lists, and columns

• Create a new SharePoint Online site using Create a SharePoint Online site using Power Automate
• Create a communication site with Create a SharePoint Online communication site using Power Automate
• Create lists and columns from Excel via Create SharePoint Online list and columns from Excel using Power Automate
• Create multiple sites from Excel using Create multiple sites in SharePoint Online using Power Automate from Excel
• Create a SharePoint list lookup column via Create SharePoint list lookup column using Power Automate
• Create image columns in lists with Power Automate create image column in SharePoint list
• Create location columns in lists via Power Automate create location column in SharePoint list
• Create indexed columns automatically using Create SharePoint indexed columns using Power Automate
• Disable Title as mandatory field with Disable Title as mandatory field from SharePoint list using Power Automate
• Add site columns to a content type using Add site columns to SharePoint content type using Power Automate

Views, navigation, and list metadata

• Create list views using REST via Create SharePoint list view REST API in Power Automate
• Create list views using actions with Create SharePoint list views using Power Automate
• Get and delete list views via Get and delete a SharePoint list view using Power Automate
• Add a list to Quick Launch using Add SharePoint list to Quick Launch using Power Automate
• Get list column details via Get SharePoint list column details using Power Automate
• Check if a SharePoint list already exists with Check if SharePoint list already exists in Power Automate
• Check if a SharePoint list is empty via Check if SharePoint list is empty in Power Automate
• Rename a SharePoint list using Rename SharePoint list using Power Automate

Permissions, groups, and site owners

• Break permission inheritance automatically with Break permission inheritance in SharePoint Online using Power Automate
• Create SharePoint groups via Create SharePoint group using Power Automate
• Add site owners using REST with Add SharePoint site owners using REST API in Power Automate
• Extract site owner emails via Extract SharePoint site owner email using Power Automate
• Remove users from a group using Remove user from SharePoint group Power Automate
• Update user profile data using Update user profile data in Office 365 using Power Automate
• Check if a SharePoint site already exists with Check if SharePoint site already exists in Power Automate
• Get tenant name details using Power Automate get tenant name

Get, filter, update, and delete list items

• Get SharePoint list items using Power Automate get items
• Get items with OData filter queries via Power Automate OData filter query
• Fix contains‑filter errors with Power Automate SharePoint get items filter query contains is not valid
• Retrieve list items for a date range using Retrieve SharePoint list items date range Power Automate
• Apply filter between dates via Apply filter between dates in Power Automate
• Count list items using Count items in SharePoint list Power Automate
• Update list items in desktop flows via Update items in a SharePoint list in Power Automate Desktop
• Delete all items in a list using Power Automate delete all items in SharePoint list
• Update list fields with today’s date via Update SharePoint list field with today’s date in Power Automate
• Check if attachment exists on list item using Check if attachment exists using Power Automate

Files and document library automation

• Create files in SharePoint using Create a file in Power Automate
• Create SharePoint files via REST with Power Automate create SharePoint files REST API
• Copy files between locations using Power Automate copy files
• Copy and rename a file via Copy and rename file in Power Automate
• Copy files on create/modify using Power Automate copy file when a file is created or modified in SharePoint
• Copy SharePoint files between tenants via Copy SharePoint files from one tenant to another tenant using Power Automate
• Delete files from libraries using REST with Delete files from SharePoint document library using REST API in Power Automate
• Check if a file exists in a library using Check if a file exists in the SharePoint document library in Power Automate
• Get folder path of a library via Get SharePoint document library folder path in Power Automate
• Handle file‑locked errors using File locked for shared use error in Power Automate
• Fix duplicate name save errors via A file with the same name is currently being saved to this site error in Power Automate
• Rename SharePoint files using REST with Rename SharePoint file REST API Power Automate

REST API and advanced SharePoint operations

• Understand REST usage with REST API in Power Automate
• Get all list items with pagination via Get all SharePoint list items using REST API pagination in Power Automate
• Get list attachments with REST using Get SharePoint list attachments Power Automate REST API
• Send emails using REST via Send email using REST API in Power Automate

Forms, XML, and data import into SharePoint

• Save Microsoft Forms responses and attachments to SharePoint with Save Microsoft Forms responses and attachments to SharePoint lists using Power Automate
• Export list items to Excel using Export SharePoint list items to Excel using Power Automate
• Convert XML data into a SharePoint list via Convert XML to SharePoint list using Power Automate

3. Dataverse and data integration

Use this section when your flows work with Dataverse, AI Builder, Excel, CSV, and other data sources. These tutorials help you create and update Dataverse rows, import data, transform it between formats, and connect Power Automate to data in SharePoint, Excel, and beyond.

Dataverse rows, choices, and lookups

• Add new Dataverse records using Power Automate Dataverse add new row
• Update existing Dataverse rows via Update a row in Dataverse using Power Automate
• Get who created a Dataverse record with Get Dataverse created by in Power Automate
• Work with Dataverse choice columns using Get choice column value from Dataverse using Power Automate

Importing data to Dataverse and Excel

• Import CSV file records into Dataverse using Import CSV data to Dataverse Power Automate
• Convert invoice details into Excel with AI using Convert invoice details to Excel AI Builder Power Automate
• Create an array from an Excel table using Create an array from an Excel table using Power Automate
• Add rows to Excel tables via Add rows to Excel in Power Automate
• Copy data from one Excel file to another using Copy data from one Excel to another Excel in Power Automate
• Send emails directly from Excel data with Send email from Excel using Power Automate

AI Builder and document data extraction

• Extract invoice data automatically with AI using Extract data from PDF invoices automatically using Power Automate
• Extract invoice details saved in SharePoint via Extract invoice details from SharePoint Power Automate AI Builder
• Convert invoice details to structured Excel with Convert invoice details to Excel AI Builder Power Automate
• Perform entity extraction from text using Entity extraction in Power Automate (AI Builder)
• Extract data from Word documents to Excel using Extract data from Word documents to Excel using Power Automate Desktop

CSV, HTML tables, and tabular data

• Import CSV data into Dataverse via Import CSV data to Dataverse Power Automate
• Create an HTML table from Excel data using Create an HTML table from Excel in Power Automate
• Create an HTML table from an array using Create an HTML table from an array in Power Automate
• Build HTML tables from any data using Create an HTML table in Power Automate

XML, JSON, and structured data integration

• Convert XML content to a string via Convert XML to string in Power Automate
• Convert XML to a SharePoint list using Convert XML to SharePoint list using Power Automate
• Convert XML to JSON with Convert XML to JSON using Power Automate
• Convert XML to an array in flows via Convert XML to array in Power Automate
• Loop through XML data and insert into Excel using Loop through XML data and insert into Excel using Power Automate

SharePoint ↔ Power Apps / Dataverse hand‑off

• Push SharePoint list data into Power Apps using SharePoint list data to Power Apps using Power Automate
• Build end‑to‑end scenarios by combining these Dataverse/Excel/CSV flows with your Power Apps Dataverse tutorials from the Power Apps hub (for example, apps that write to Dataverse and flows that keep Excel/SharePoint in sync).

4. Approvals, reminders, and notifications

Approvals and notifications are some of the most common flow scenarios.

Use this section when you want to build approval workflows, send reminders, and notify users by email, Teams, or mobile. These tutorials cover single and multi‑step approvals, custom responses, timeout handling, and different ways to notify people.

Approval flows and custom responses

• Build a full approval process from Forms responses with Power Automate approval workflow using Microsoft Forms
• Design standard approval steps using Start and wait for an approval in Power Automate
• Run approvals one after another via Power Automate sequential approval flow
• Configure multiple approvers with Set multiple approvers in Power Automate
• Send approvals to Microsoft 365 groups using Power Automate send approval to Microsoft 365 group
• Send approvals to SharePoint group members via Power Automate send approval to SharePoint group members
• Include attachments in approval emails with Power Automate add attachments in approval
• Create your own approval outcomes using Create custom responses in Power Automate approvals
• Customize approval mail text and details via Start and wait for an approval text in Power Automate
• Handle approval timeout issues with Approval timeout in Power Automate

Notifications, reminders, and email patterns

• Send reminder emails from a list using Send email reminders from a SharePoint list using Power Automate
• Trigger mobile push alerts with Send mobile notification using Power Automate
• Send standard email messages via Send an email with attachments in Power Automate
• Send email from Excel directly using Send email from Excel using Power Automate
• Send emails from a shared mailbox with Power Automate shared mailbox
• Send emails when new messages arrive with filters via When a new email arrives subject filter in Power Automate
• Send an email and mention users using Send an email with mention in Power Automate
• Send an email with multiple choice options using Send an email with options in Power Automate
• Send emails with attachments from a local folder via Send an email with attachments from local folder using Power Automate
• Automatically send birthday greetings using Send birthday wishes using Power Automate

Approvals and notifications in Teams and Outlook

• Send approvals directly in Teams using Send approvals in Microsoft Teams using Power Automate
• Build flows that work with Teams channels via Power Automate flow with Microsoft Teams
• Forward Outlook meeting invites automatically with Power Automate forward meeting invite in Outlook
• Create calendar events from SharePoint lists using Create calendar events from a SharePoint list using Power Automate
• Get display names from email addresses via Power Automate get display name from email

Monitoring failures and handling errors in notification flows

• Send emails when a flow run fails using Send email with failed flow run link in Power Automate
• Handle common connection errors with Invalid connection, please choose a connection in Power Automate
• Fix permission issues using User does not have readaccess on connection reference error in Power Automate
• Resolve unauthorized operation errors via Attempted to perform an unauthorized operation Power Automate
• Handle “user does not exist or is not unique” with The user does not exist or is not unique error in Power Automate
• Implement try/catch style patterns using Power Automate exception handling using try catch

5. Outlook, Teams, and Planner automation

Use this section when your flows need to work with Outlook emails, calendar events, Microsoft Teams, and Planner tasks. These tutorials help you route messages, schedule meetings, manage tasks, and connect collaboration tools together.

Outlook email and calendar automation

• Trigger flows when emails arrive with filters using When a new email arrives subject filter in Power Automate
• Send emails (with or without attachments) via Send an email with attachments in Power Automate
• Send emails from Excel data using Send email from Excel using Power Automate
• Send emails from a shared mailbox with Power Automate shared mailbox
• Send an email that includes @mentions using Send an email with mention in Power Automate
• Send an email with multiple choice buttons via Send an email with options in Power Automate
• Send emails with attachments from a local folder using Send an email with attachments from local folder using Power Automate
• Clean up old mailboxes with Power Automate delete emails older than
• Forward existing meeting invites automatically via Power Automate forward meeting invite in Outlook
• Create calendar events from SharePoint list items using Create calendar events from a SharePoint list using Power Automate
• Get a user’s display name from their email with Power Automate get display name from email
• Send birthday greetings automatically using Send birthday wishes using Power Automate

Microsoft Teams automation

• Build flows that post messages and interact with Teams using Power Automate flow with Microsoft Teams
• Send approvals directly into Teams with Send approvals in Microsoft Teams using Power Automate
• Add new attendees to an existing meeting (without emailing others) using Add new attendee to meeting without email others Power Automate

Planner tasks and work management

• Create tasks in Planner automatically using Power Automate create a task in Microsoft Planner

Cross‑tool notification and monitoring patterns

• Send mobile push notifications to users via Send mobile notification using Power Automate
• Notify when a flow run fails by email using Send email with failed flow run link in Power Automate

6. Files, PDFs, Excel, and Word automation

This section is for anything that touches files: creating PDFs, merging documents, creating and updating Excel, Word generation, QR code generation, and file system automation.

6. Files, PDFs, Excel, and Word automation

Use this section whenever your flows need to work with files and documents: creating and merging PDFs, generating Word files, updating Excel, and moving documents around in SharePoint or the file system.

• Generate PDFs from data using Power Automate create PDF
• Create a PDF from SharePoint list items using Create a PDF from SharePoint list items using Power Automate
• Merge multiple PDF files in the cloud via Merge PDF files in Power Automate
• Merge PDF files on the desktop using Merge PDF files in Power Automate Desktop
• Create a file in SharePoint or other locations with Create a file in Power Automate
• Create SharePoint files using REST API via Power Automate create SharePoint files REST API
• Copy files between folders or libraries using Power Automate copy files
• Copy and rename a file in one go with Copy and rename file in Power Automate
• Copy files when they are created or modified using Power Automate copy file when a file is created or modified in SharePoint
• Copy SharePoint files between tenants via Copy SharePoint files from one tenant to another tenant using Power Automate
• Add rows into an Excel table using Add rows to Excel in Power Automate
• Create an array from Excel rows via Create an array from an Excel table using Power Automate
• Copy Excel data between files using Copy data from one Excel to another Excel in Power Automate
• Loop through Excel rows in desktop flows with Power Automate Desktop loop through Excel rows
• Extract data from Word documents into Excel using Extract data from Word documents to Excel using Power Automate Desktop
• Create a Word document from SharePoint list data with Create a Word document from a SharePoint list item using Power Automate
• Generate a Word file from HTML content via Create a Word document from HTML using Power Automate
• Replace text in an existing Word document using Replace text in a Word document in Power Automate
• Export SharePoint list data to Excel using Export SharePoint list items to Excel using Power Automate
• Create HTML tables from Excel data via Create an HTML table from Excel in Power Automate
• Build HTML tables from arrays using Create an HTML table from an array in Power Automate
• Create HTML tables from any data source with Create an HTML table in Power Automate
• Send emails with attachments pulled from local folders using Send an email with attachments from local folder using Power Automate
• Send emails with attachments from SharePoint or OneDrive via Send an email with attachments in Power Automate
• Handle “file locked” issues with File locked for shared use error in Power Automate
• Fix duplicate‑name save problems via A file with the same name is currently being saved to this site error in Power Automate
• Check whether a file exists before creating it using Check if a file exists in the SharePoint document library in Power Automate
• Rename SharePoint files using REST with Rename SharePoint file REST API Power Automate

7. Arrays, JSON, XML, and advanced expressions

These tutorials go deep into data‑shaping: arrays, strings, JSON, XML, GUIDs, OData filter queries, and complex expression tricks. Use this section to fix tricky expression errors and handle complex transformations.

Use this section whenever you need to shape data in Power Automate: arrays, strings, JSON, XML, GUIDs, number and date formatting, or complex conditions. These tutorials help you solve the “expression errors” that come up in real‑world flows.

• Split a string into elements using Split a string into an array in Power Automate
• Split and return only the first value via Power Automate split string get first value
• Convert a string to an array with Convert a string to an array in Power Automate
• Append multiple values to an array using Append multiple values to an array in Power Automate
• Append a single string item into an array via Append a string to an array in Power Automate
• Convert an integer value to an array using Convert an integer to an array in Power Automate
• Convert array values back to a string with Convert an array to a string using Power Automate
• Count how many items are in an array using Count items in an array using Power Automate
• Filter arrays by conditions via Power Automate filter array
• Check whether an array is empty using Check if array is empty in Power Automate
• Check if an array contains a value with Check if an array contains value using Power Automate
• Replace specific characters in text using Replace characters in Power Automate
• Remove unwanted characters from a string via Remove characters from string in Power Automate
• Extract part of a string using Extract substring from text using Power Automate Desktop
• Convert string to integer using Convert string to integer in Power Automate
• Convert string to decimal via Convert string to decimal in Power Automate
• Convert float values to integers with Convert float to integer in Power Automate
• Round numbers up or down using Convert a number to rounding up or down in Power Automate
• Format numbers as currency via Format a number as currency in Power Automate
• Format numbers to percentage with Format number to percentage in Power Automate
• Format numbers with thousand separators using Format number thousand separator in Power Automate
• Format numbers without decimals via Format number without decimal in Power Automate
• Format numbers to specific decimal places using Format numbers to decimal places using Power Automate
• Add leading zeros to numbers via Format numbers with leading zeros using Power Automate
• Convert percentage values to whole numbers using Convert percentage to whole number in Power Automate
• Convert decimal to whole number via Convert decimal to whole number Power Automate
• Convert a number to hexadecimal using Convert a number to hexadecimal in Power Automate
• Convert numeric values to dates via Convert number to date in Power Automate
• Convert any value to string using Convert value to string in Power Automate
• See more options in Power Automate number format
• Format dates and times using Power Automate formatDateTime
• Convert between time zones via Power Automate convert time zone
• Add days to a date with Power Automate add days to date
• Check if a date is a weekend using Check if the date is weekend in Power Automate
• Work with days of the week via DayOfWeek function in Power Automate
• Convert string to date for SharePoint using Convert string to date for SharePoint list using Power Automate
• Fix ISO date format errors via The datetime string must match ISO 8601 format in Power Automate
• Convert string values to GUID with Convert string to GUID in Power Automate
• Generate brand new GUIDs using Generate new GUID in Power Automate
• Convert strings into objects via Convert string to object in Power Automate
• Work with XML content by converting XML to string using Convert XML to string in Power Automate
• Convert XML to JSON via Convert XML to JSON using Power Automate
• Convert XML to array using Convert XML to array in Power Automate
• Convert XML into SharePoint list items with Convert XML to SharePoint list using Power Automate
• Loop through XML and insert into Excel via Loop through XML data and insert into Excel using Power Automate
• Remove extra properties from objects using Remove unwanted properties from an object using Power Automate
• Handle nesting limit issues via Power Automate which exceeds the maximum nesting limit of 8
• Implement robust try/catch error handling with Power Automate exception handling using try catch

8. Power Automate Desktop and RPA patterns

This section is for desktop automation scenarios: working with Excel in PAD, SharePoint from PAD, loops, concatenation, mathematical operations, and handling errors in desktop flows.

8. Power Automate Desktop and RPA patterns

Use this section when you are automating tasks on your desktop: working with SharePoint, Excel, data tables, loops, and math in Power Automate Desktop (PAD). These tutorials help you build robust RPA flows that work reliably on your machine.

• Update list items from the desktop using Update items in a SharePoint list in Power Automate Desktop
• Merge PDF files locally via Merge PDF files in Power Automate Desktop
• Format dates inside desktop flows using Power Automate Desktop format date
• Concatenate text values in PAD with Power Automate Desktop concatenate strings
• Perform mathematical calculations in PAD using Power Automate Desktop mathematical operations
• Work with data tables inside desktop flows via Data table in Power Automate Desktop
• Convert data table columns into lists using Convert data table columns to list in Power Automate Desktop
• List and inspect variables during development with List variables in Power Automate Desktop
• Loop over actions repeatedly using Loop actions in Power Automate Desktop
• Loop through Excel rows in RPA scenarios via Power Automate Desktop loop through Excel rows
• Create SharePoint files from PAD using Create file in SharePoint using Power Automate Desktop
• Create and delete SharePoint list items from PAD via Create and delete an item from a SharePoint list using Power Automate Desktop
• Get list items from SharePoint in PAD using Get items from SharePoint list using Power Automate Desktop
• Filter SharePoint items in PAD via Power Automate Desktop SharePoint get items filter query
• Extract substring parts in desktop flows using Extract substring from text using Power Automate Desktop
• Handle file/content type issues with Argument body must be binary in Power Automate Desktop
• Automate Word → Excel extraction scenarios via Extract data from Word documents to Excel using Power Automate Desktop

9. Real‑world business scenarios, REST API, and Copilot

Finally, this section gathers full business scenarios and advanced integrations: REST API calls, SharePoint admin automations, tenant‑level operations, AI Builder invoice extraction, weather flows, Copilot Studio integration, and more.

• Automate expense reimbursement and approvals using Expense reimbursement and approval using Power Automate
• Export SharePoint list items to Excel for reporting via Export SharePoint list items to Excel using Power Automate
• Create multiple SharePoint Online sites from Excel using Create multiple sites in SharePoint Online using Power Automate from Excel
• Send Teams‑based approvals with Send approvals in Microsoft Teams using Power Automate
• Send approval requests to Microsoft 365 groups via Power Automate send approval to Microsoft 365 group
• Send approvals to SharePoint group members using Power Automate send approval to SharePoint group members
• Extract data from PDF invoices automatically with AI using Extract data from PDF invoices automatically using Power Automate
• Extract invoice details stored in SharePoint via Extract invoice details from SharePoint Power Automate AI Builder
• Convert invoice details to structured Excel with Convert invoice details to Excel AI Builder Power Automate
• Get a weather forecast and use it in flows using Get weather forecast using Power Automate
• Generate a QR code automatically via Generate QR code using Power Automate
• Compare tools and migration options using Power Automate vs Nintex
• Call SharePoint REST endpoints from flows via REST API in Power Automate
• Delete files from document libraries using REST with Delete files from SharePoint document library using REST API in Power Automate
• Create SharePoint files using REST via Power Automate create SharePoint files REST API
• Get all list items with REST pagination using Get all SharePoint list items using REST API pagination in Power Automate
• Get list attachments with REST via Get SharePoint list attachments Power Automate REST API
• Send emails via REST endpoint using Send email using REST API in Power Automate
• Save Microsoft Forms responses and attachments into SharePoint lists using Save Microsoft Forms responses and attachments to SharePoint lists using Power Automate
• Convert XML data to SharePoint list items via Convert XML to SharePoint list using Power Automate
• Loop through XML and insert rows into Excel using Loop through XML data and insert into Excel using Power Automate
• Add Copilot Studio knowledge files automatically from flows using Add Copilot Studio knowledge files Power Automate

How to use this Power Automate tutorials hub

You can use this Power Automate hub as a full learning path or as a quick reference. If you are new, start with Fundamentals and expressions, then move into SharePoint automation and Approvals and notifications. If you are already building flows, scroll down to the section that matches your current problem—there is almost certainly a tutorial you can adapt.

As Power Automate keeps evolving—with more connectors, AI Builder capabilities, and Copilot integration—this hub will be updated with new tutorials so you always have a practical library of flow patterns to learn from.

Explore other tutorial hubs

To build complete solutions, combine Power Automate with the rest of the Power Platform and Microsoft 365. Use these hubs alongside your flows:

• Build apps that trigger flows with all Power Apps tutorials
• Automate SharePoint solutions with all SharePoint tutorials
• Build modern client‑side solutions with all SPFx tutorials
• Design portals with all Power Pages tutorials
• Build reports and dashboards with all Power BI tutorials
• Improve collaboration with all Microsoft Teams tutorials
• Build AI copilots and bots with all Copilot Studio tutorials
• Automate admin tasks with all PowerShell tutorials

Join the premium SPGuides Academy

If you want to go beyond single flow examples and build complete automation solutions, you can join my premium SPGuides Academy. Inside, you will find full courses and real‑time projects that combine Power Automate with SharePoint, Power Apps, Power BI, Dataverse, and Copilot to solve real business problems.

As a member, you can follow structured learning paths, download ready‑to‑use flows, and watch step‑by‑step implementations—from designing triggers and conditions to handling errors, performance, and governance in production environments.

Final thoughts

This Power Automate tutorials hub is designed to be your central library of automation patterns—from simple email reminders to complex REST‑based SharePoint admin flows and AI‑powered document processing. With 200+ tutorials organized into 9 sections, you can quickly find exactly the pattern you need and adapt it to your environment.

The more you use this hub to build real flows, the faster you can turn manual processes into reliable, automated solutions that save you and your team hours of repetitive work.