Re: Overwriting current Sharepoint list items with data from an Excel
Hi @Misa
Can a flow be created to update the Sharepoint list based on the employee ID?
Yes.
First read the excel sheet to get each rows. Not sure how you want to trigger. There are many ways you could trigger by schedule or when a file is added or modified?
You need the 'SharePoint Get Items' flow action Filtery Query by Employee Id to get the list item id.
Once you get the list item id you can update the 'SharePoint Update Item' flow action.
Most likely the number of rows may differ every month, would this be a problem?
No. You can read the excel sheet from a specified location whether its stored in SharePoint or Onedrive.
Can the rows in Sharepoint that were not in the excel document be deleted or archved by moving to a new list?
Yes it is possible. You can delete the list by using 'SharePoint Delete Item' by passing the item id.
If you want to move to a new list then first read the current list using 'SharePoint - Get Item' and use the 'SharePoint Create Item' flow action to create the list in a new location. Then delete the old list item.
If you need any help please let me know.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Thanks
Share
Report
246
All responses (
Answers (
