Power Automate Intermediate Course: Expressions, Approvals and Reliable Flows

The beginner course built simple cloud flows. This course makes them dependable: expressions for dates, text and numbers (including India time zone and rupee text), Excel tables done right, approvals with routing by amount, loops and arrays, scheduled reminders, error handling and monitoring, and a final invoice-processing project.

Practice files include Excel tables ready for the connectors, an expression cheat sheet whose example results we checked, and an approval flow outline. The flows themselves run in your Microsoft 365 account.

Before you start: the Power Automate Beginner Course and a Microsoft 365 work or school account.

1. 1Power Automate Intermediate Lesson 1: Expressions for Dates, Text and NumbersWrite Power Automate expressions: formatDateTime, convertFromUtc to India Standard Time, addDays, concat, split, replace and float for rupee text, with results.
2. 2Power Automate Intermediate Lesson 2: Excel Tables Done RightUse the Excel Online connector without surprises: real tables, List rows with filters, ISO dates instead of serial numbers, adding and updating…
3. 3Power Automate Intermediate Lesson 3: Approvals Routed by AmountBuild an expense approval: auto-approve small claims, send large ones to the finance head, record the outcome and comments in Excel and…
4. 4Power Automate Intermediate Lesson 4: Apply to Each, Arrays and SelectLoop through rows and attachments, build arrays with Select and Filter array, join them into one email table, and speed up loops…
5. 5Power Automate Intermediate Lesson 5: Error Handling With Scopes and Run AfterMake flows fail loudly and recover: Try/Catch scopes, Configure run after, retry policies, the run link in alerts and terminate with a…
6. 6Power Automate Intermediate Lesson 6: Scheduled Reminders That Don’t SpamA daily flow that emails customers 3 days before an invoice is due, marks them reminded so nobody gets two mails, and…
7. 7Power Automate Intermediate Lesson 7: Monitoring, Ownership and SharingKeep flows running when people leave: co-owners and service accounts, run history and analytics, connection references, solutions, and the licence limits to…
8. 8Power Automate Intermediate Lesson 8: Project – Invoice Processing From EmailFinal project: save invoice attachments from email to dated OneDrive folders, log them in Excel, route big invoices for approval and alert…

Pair it with Outlook Intermediate and Office Scripts.