Hi There,
Yes, you can achieve this using a combination of Power Automate and SharePoint:
Create a dedicated SharePoint Document Library to upload your weekly Excel files.
Create a Power Automate Flow. Use the "When a file is created or modified (properties only)" trigger for the Document Library where you'll upload the Excel file. Use the "List rows present in a table" Excel action to retrieve rows from the uploaded Excel.
Loop through each row. Check if the record exists in the SharePoint list using "Get items" SharePoint action with suitable filters.
If it exists, use the "Update item" SharePoint action to update the record and highlight (e.g., by setting a dedicated column value or changing a color if using column formatting). If it doesn't exist, use the "Create item" SharePoint action to add a new record.
InSharePoint List, Create a Yes/No column named "Updated" in the SharePoint list. Every time you update a record through the flow, set the "Updated" column to "Yes". Use SharePoint Column Formatting to visually highlight rows where the "Updated" column is "Yes".
Please give kudos and mark as solution if it helps.
Thanks,
Sandeep Mishra
