Emails, attachments, and files
Save Outlook attachments, filter the files you actually want, route them to the correct folder, create folders, rename files, and confirm receipt only after the required work succeeds.
MICROSOFT POWER AUTOMATE WORKFLOW GUIDE
Automate the Office
30 Practical Workflows Using Microsoft Power Automate for Outlook, Excel, Forms, SharePoint and Teams
By Mercer Lane · Published by Mercer Lane Press
A practical Microsoft 365 workflow guide built around 30 Power Automate examples for email attachments and files, Forms and SharePoint requests, approvals, overdue work, Excel processing, Teams notifications, reporting, troubleshooting, and maintenance.
WHO IT IS FOR
For Microsoft 365 users who need repeatable office work to become reliable workflows
Microsoft 365 users who handle repeatable office administration and want to turn defined processes into maintainable Power Automate flows without treating automation as a black box.
- Repetitive email, attachment, file, request, approval, reminder, spreadsheet, and reporting work
- Flows that run but do not produce the intended business result
- Duplicate processing or unsafe reruns after a partial failure
- Confusion about triggers, actions, dynamic content, conditions, loops, connections, permissions, and run history
- Automations that work for one person but are difficult to hand over or maintain
30 PRACTICAL WORKFLOWS
The book follows real office work from trigger to maintenance
The examples are organized around seven areas: deciding what to automate; emails, attachments, and files; Forms and SharePoint; approvals and overdue work; Excel automation; Teams, requests, and reporting; and diagnosing automation when it goes wrong.
Forms and SharePoint
Create tracked requests, handle uploaded files, generate readable references, update the correct record, and send confirmation from authoritative process state.
Approvals and overdue work
Build single and multi-stage approvals, record outcomes, send reminders, and escalate overdue work without sending the same notification forever.
Excel automation
Process table rows, send personalized emails, transfer records to SharePoint, process uploaded workbooks, prevent duplicate row processing, and build recurring reports.
Teams and reporting
Notify channels only when something significant happens, route requests through maintained mappings, build a central action tracker, and produce repeatable status and executive-summary workflows.
Troubleshooting and maintenance
Read run history, distinguish connection from permission problems, diagnose loops, preserve ownership and handover information, and know when a process should stay manual.
HOW THE METHOD WORKS
Build the smallest version, then prove the business result
Start with a controlled test flow
Create an instant flow with a manual trigger and one simple action, then inspect run history so the basic cycle of trigger, action, evidence, and result is familiar before adding complexity.
Design the second run
A first successful run is not enough. Decide what should happen if the same event arrives twice, if an earlier action succeeded before a later action failed, or if the flow is rerun.
Separate facts from interpretation
Use deterministic source data for counts, status, identity, and routing. Where judgement or generated narrative is involved, keep the source facts visible and preserve human review where it matters.
Scope. The book focuses on everyday Microsoft 365 office work involving Outlook, Excel, Microsoft Forms, SharePoint, Teams, approvals, reminders, and reporting. It does not try to cover Power Automate Desktop/RPA, PL-500 certification, advanced Dataverse architecture, custom connectors, or unattended desktop automation.
FREE SUPPORTING GUIDES
Use the web guides for focused build and troubleshooting questions
POWER AUTOMATE GUIDE
What Is Actually Worth Automating With Power Automate?
Good automation candidates are repetitive, predictable, structured enough to define, and recoverable when something goes wrong. Standardize the process before automating it.
Read the guidePOWER AUTOMATE GUIDE
Power Automate: Save Outlook Attachments to SharePoint
Start with one controlled mailbox and one test library. Prove that the correct attachment content reaches SharePoint before adding filename rules, routing, and notifications.
Read the guidePOWER AUTOMATE GUIDE
Build a Forms-to-SharePoint Request Tracker That Can Be Recovered
Create the SharePoint item first, use its real item ID as the record identity, derive a readable reference from that stable ID, and update the exact item rather than searching for it again.
Read the guidePOWER AUTOMATE GUIDE
Process Excel Rows in Power Automate Without Duplicating the Work
Use a real Excel table, a stable row identity, explicit source process state, and a destination uniqueness check. Mark the source complete only after the required business action succeeds.
Read the guidePOWER AUTOMATE GUIDE
Send Overdue Reminders in Power Automate Without Repeating the Same Mistake
Define overdue precisely, retrieve only open overdue items, send one useful message per returned item, and record reminder or escalation state when repeated notifications need control.
Read the guidePOWER AUTOMATE GUIDE
How to Diagnose a Failed Power Automate Flow With Run History
The designer shows intent; run history shows evidence. Read the exact run from the trigger downward until you find the first action that failed or produced the wrong data.
Read the guideSEARCH BY THE PROBLEM
Power Automate examples for the office tasks people search for most
A recurring search is how to save email attachments to SharePoint with Power Automate. Related searches focus on SharePoint approval flows, deadline reminders, Forms processing, Excel rows and Teams notifications. The book brings those common Microsoft 365 workflows into one build-and-troubleshoot system.
Questions this guide is designed to help with
- How do I save email attachments to SharePoint with Power Automate?
- How do I create a SharePoint approval flow in Power Automate?
- How do I send deadline and overdue reminders with Power Automate?