Power Automate Intermediate Lesson 5: Error Handling With Scopes and Run After
Make flows fail loudly and recover: Try/Catch scopes, Configure run after, retry policies, the run link in alerts and terminate with a clear status.
Read article →Automation
Stop doing it by hand: VBA, Python, SAP GUI scripting, Power Automate, Office Scripts and AutoHotkey.
Power Automate Intermediate Lesson 4: Apply to Each, Arrays and Select
Power Automate Intermediate Lesson 4: Apply to Each, Arrays and Select
Loop through rows and attachments, build arrays with Select and Filter array, join them into one email table, and speed up loops with concurrency.
Read article →Power Automate Intermediate Lesson 3: Approvals Routed by Amount
Power Automate Intermediate Lesson 3: Approvals Routed by Amount
Build an expense approval: auto-approve small claims, send large ones to the finance head, record the outcome and comments in Excel and email the…
Read article →Power Automate Intermediate Lesson 2: Excel Tables Done Right
Power Automate Intermediate Lesson 2: Excel Tables Done Right
Use the Excel Online connector without surprises: real tables, List rows with filters, ISO dates instead of serial numbers, adding and updating rows by…
Read article →Power Automate Intermediate Lesson 1: Expressions for Dates, Text and Numbers
Power Automate Intermediate Lesson 1: Expressions for Dates, Text and Numbers
Write Power Automate expressions: formatDateTime, convertFromUtc to India Standard Time, addDays, concat, split, replace and float for rupee text, with results.
Read article →Power Automate Lesson 3: Save Email Attachments to OneDrive
Power Automate Lesson 3: Save Email Attachments to OneDrive
Automatically save invoice attachments to a OneDrive or SharePoint folder: attachment trigger, Apply to each, file names with dates, and skipping signature images.
Read article →Power Automate Lesson 7: Power Automate Desktop — Your First Desktop Flow
Power Automate Lesson 7: Power Automate Desktop — Your First Desktop Flow
Automate Windows apps and websites with Power Automate Desktop: install, recorder, UI elements, variables, Excel actions and a flow that copies data from a…
Read article →Power Automate: Save Email Attachments to OneDrive Automatically
Power Automate: Save Email Attachments to OneDrive Automatically
Build a Power Automate cloud flow that saves attachments from specific Outlook emails into OneDrive or SharePoint folders — with filters, date folders and…
Read article →Power Automate Desktop: Build Your First Flow to Rename and Sort Files
Power Automate Desktop: Build Your First Flow to Rename and Sort Files
Build a first Power Automate Desktop flow that renames downloaded reports with today’s date and moves them into monthly folders — step by step,…
Read article →Merge 100 Excel Files into One with Python (in 10 Lines)
Merge 100 Excel Files into One with Python (in 10 Lines)
Combine every Excel file in a folder into one sheet with Python and pandas — with a source column, header checks and a summary.
Read article →Power Automate Lesson 8: Error Handling, Run History and Good Habits
Power Automate Lesson 8: Error Handling, Run History and Good Habits
Keep flows reliable: run history, Configure run after for failure branches, scopes for try/catch, notifications on failure, naming, ownership and documentation.
Read article →Power Automate Lesson 6: Forms to Excel and Teams
Power Automate Lesson 6: Forms to Excel and Teams
Send Microsoft Forms responses into an Excel table and post a summary to a Teams channel: get response details, add a row, adaptive messages…
Read article →