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