Share
ReportHi, Any way to do it - Use case each week I get a updated excel. How can I upload from a list form so it will update the list and updated records will be highlighted?
You’re offline. This is a read only version of the page.
Hi, Any way to do it - Use case each week I get a updated excel. How can I upload from a list form so it will update the list and updated records will be highlighted?
@sandeepstw - Sandeep, Will it be possible to provide a sample / power automate screen shot that you mentioned so I can follow it please .
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
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
All responses (
Answers (
