Power Automate: Automatically Add New SharePoint Items to Excel (Step-by-Step Tutorial)
Automatically add new SharePoint list items to an Excel table — without any manual work.
In this Power Automate tutorial, I’ll show you how to create a flow that adds every new SharePoint list item directly into your Excel file stored in the Shared Documents library.
Use Case: Keep your Excel reports or dashboards instantly updated whenever new items are added to your SharePoint list.
Example fields used: Description, Department, and Priority.
⏱ What you’ll learn:
Trigger a flow when a SharePoint item is created
Connect Excel stored in Shared Documents
Create a proper Excel table Power Automate can write to
Map SharePoint columns to Excel columns
Test and confirm your automatic sync
Perfect for automating data tracking, reporting, and team lists in Microsoft 365.
💡 Subscribe for more Power Automate tutorials every week!
Chapters:
00:00 Intro — Automate SharePoint to Excel
00:20 Flow trigger: When a SharePoint item is created
00:32 Excel file setup in Shared Documents
00:50 Create an Excel table fit for Power Automate
01:13 Save and test your flow
01:46 Outro — Like, comment, and subscribe