How to synchronize SharePoint items to Excel in Power Automate

João Barros 04 de September de 2026 4 min read

This tutorial shows how to synchronize items from a SharePoint list to an Excel file in OneDrive/SharePoint using Power Automate. It is useful for having offline reports, feeding dashboards or sharing data with people who do not use SharePoint.

Prerequisites

Microsoft account with access to Power Automate.
SharePoint list with simple columns (Text, Number, Date).
Excel file with a formatted table (Table1) stored in OneDrive or SharePoint.
Permissions to create/edit flows and access the files/lists.

Step 1: Structure the Excel table

Why: Power Automate writes to Excel tables, not to loose sheets. Open Excel Online or Desktop, create a table with headers identical to the column names of the SharePoint list (e.g.: ID, Title, Status, Date). Select the data and insert the table; verify the name is Table1 (or adjust in the flow).

Step 2: Create a new automated flow

Why: we want the synchronization to run when an item is created or modified. In Power Automate, create a flow of type "Automated cloud flow" with the trigger "When an item is created or modified" (SharePoint).

Step 3: Configure the SharePoint trigger

Explanation: choose the Site Address and the List Name. This ensures the flow triggers whenever a user creates or modifies an item.

// Trigger (configuração no UI) // Site Address: https://.sharepoint.com/sites/ // List Name: NomeDaLista

Step 4: Get rows from the Excel table to avoid duplicates

Why: if you want to update existing rows instead of always appending, you need to check whether the SharePoint item ID already exists in the Excel table. Use the action "List rows present in a table" (Excel Online (Business)).

// Ação: List rows present in a table // Location: OneDrive for Business ou SharePoint // Document Library: OneDrive // File: /Documents/Exports/Sync.xlsx // Table: Table1

Step 5: Find the corresponding row

Explanation: add a "Filter array" action to search the output of List rows for the row with the same ID as the SharePoint item. Use an expression to compare: item()?['ID'] or the column where you stored the ID.

// Filter array (condição) // From: body('List_rows_present_in_a_table')?['value'] // Condition: item()?['ID'] == triggerBody()?['ID']

Step 6: Condition for Insert or Update

Explanation: add a "Condition" action that checks if the filtered array has length() > 0. If it exists, update the row; if not, insert a new row.

// Expression para Condition length(body('Filter_array')) > 0

Step 7: Update an existing row

For the "If yes" branch: use the "Update a row" action (Excel Online (Business)). We need the key column and key value — normally the table's ID column. Use the expression that gets the first item from the filter: body('Filter_array')[0]?['ID'] or the key you configured.

// Update a row // Key Column: ID // Key Value: body('Filter_array')[0]?['ID'] // Preencher colunas: Title = triggerBody()?['Title'], Status = triggerBody()?['Status'], Data = triggerBody()?['Data']

Step 8: Insert a new row

For the "If no" branch: use the "Add a row into a table" action. Map the columns to the fields from the SharePoint trigger. This adds a row when the item is new.

// Add a row into a table // Table: Table1 // Colunas: ID = triggerBody()?['ID'], Title = triggerBody()?['Title'], Status = triggerBody()?['Status'], Data = triggerBody()?['Data']

Step 9: Handle common errors

Frequent errors: insufficient permissions, Excel file open in Excel Desktop causing a lock, different column names. Quick fixes: ensure permissions, close the file or use a file in OneDrive/SharePoint with the proper connection, check the table headers.

Verify the result

Create or modify an item in the SharePoint list and check the Excel file. You should see a new row for new items and updates for existing items. In the flow run history in Power Automate you can see each execution and the outputs of each action for debugging.

Conclusion

You now have a flow that synchronizes SharePoint items to Excel, with logic to avoid duplicates and update rows. Next steps: add mapping of more columns, handle attachments or run bulk synchronization using "Recurrence". Tip: test with small sets and use the "Compose" action to inspect values during development.