Power Automate

Explore ExcelGuru’s Power Automate tutorials and guides to automate Excel workflows, connect Microsoft 365 apps, reduce manual tasks, and build smarter business processes without complex coding.

Send Excel reports via email on a schedule tutorial showing Power Automate Outlook scheduled workflows and automated report delivery

Send Excel Report via Email on Schedule

Automate recurring report distribution by scheduling Excel reports to be emailed automatically. This tutorial explains how to create a scheduled Power Automate flow, attach Excel workbooks or reports, configure Outlook email actions, define recipients, set delivery frequency, and monitor workflow execution. Ideal for analysts, managers, finance teams, HR professionals, and Microsoft 365 users who want to eliminate manual report sharing and ensure timely communication.

Add a row to an Excel table on form submission tutorial showing Microsoft Forms Power Automate Excel tables and automated workflows

Add Row to Excel Table on Form Submission

Automate data collection by adding a new row to an Excel table whenever a form is submitted. This tutorial explains how to connect form responses to Excel, configure automated workflows, map form fields to table columns, handle new records, and maintain structured datasets with minimal manual effort. Ideal for Microsoft 365 users, HR teams, administrators, educators, and business professionals who want to streamline data entry and automate reporting.

Automate Excel to PDF conversion from OneDrive or SharePoint with this practical tutorial. Learn how to use Power Automate to trigger PDF creation, select Excel files, convert worksheets or workbooks, save PDF copies, and manage output folders in cloud storage. Ideal for Excel users, admin teams, finance teams, operations teams, and professionals who want to automate report generation, reduce manual exports, and manage PDF files more efficiently.

Convert Excel to PDF on OneDrive/SharePoint

Automate Excel to PDF conversion from OneDrive or SharePoint with this practical tutorial. Learn how to use Power Automate to trigger PDF creation, select Excel files, convert worksheets or workbooks, save PDF copies, and manage output folders in cloud storage. Ideal for Excel users, admin teams, finance teams, operations teams, and professionals who want to automate report generation, reduce manual exports, and manage PDF files more efficiently.

Automate data transfer from Excel to SharePoint with this practical tutorial. Learn how to copy Excel rows into a SharePoint List using Power Automate, Excel tables, SharePoint columns, scheduled flows, trigger conditions, and basic data mapping. Ideal for Excel users, admin teams, operations teams, finance teams, and professionals who want to reduce manual data entry, keep SharePoint lists updated, and improve workflow automation.

Copy Excel Rows to SharePoint List Automatically

Automate data transfer from Excel to SharePoint with this practical tutorial. Learn how to copy Excel rows into a SharePoint List using Power Automate, Excel tables, SharePoint columns, scheduled flows, trigger conditions, and basic data mapping. Ideal for Excel users, admin teams, operations teams, finance teams, and professionals who want to reduce manual data entry, keep SharePoint lists updated, and improve workflow automation.

Power Automate: Send Email Alerts When Excel Data Changes

Send Email Alerts When Excel Data Changes

Automate email notifications from Excel when important data changes with this practical tutorial. Learn how to use VBA, worksheet change events, Outlook automation, trigger conditions, recipient lists, and custom alert messages to send emails automatically when specific cells or values are updated. Ideal for Excel users, analysts, finance teams, operations teams, and professionals who want to monitor workbook changes and automate important email alerts.