Hello
@BKayMDOT , Yes — you can manage bi-weekly updates to a large SharePoint list using Power Automate, but instead of deleting all rows and repopulating, a smarter sync flow is more efficient and scalable. This approach compares Excel and SharePoint data to update, add, or delete records as needed.
Recommended Approach: Smart Sync Flow Using Power Automate
Rather than wiping and repopulating the entire list (which is slow and risks data loss), build a flow that performs three key actions:
1. Update Existing Records
• Use “Apply to Each” to loop through rows in Excel.
• Match each row to SharePoint using a unique key (e.g., Employee ID).
• Use “Update item” if the record exists and values have changed.
2. Add New Records
• In the same loop, if no match is found in SharePoint, use “Create item” to add it.
3. Delete Missing Records
• Use a second loop to go through all SharePoint items.
• If an item’s key is not found in Excel, use “Delete item”.
This ensures your SharePoint list mirrors the Excel file without unnecessary overhead.
Helpful Resources
• Update SharePoint List Items from Excel using Power Automate
• Sync Excel to SharePoint List – Manuel T. Gomes
• Auto-Sync Data between SharePoint List and Excel – YouTube
Summary
• Use Power Automate to compare Excel and SharePoint data.
• Update, add, and delete records based on matching keys.
• Avoid full deletion — it's slower and riskier.
• Schedule the flow to run bi-weekly with concurrency enabled.
If this helped or could help others in the community, feel free to give it a like or kudo — it helps surface useful answers for everyone!
