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

Видео Power Automate: Automatically Add New SharePoint Items to Excel (Step-by-Step Tutorial) канала Automate M365