Forum Discussion
jleblanc95
Feb 19, 2021Copper Contributor
Update SharePoint list with Excel Items
I've been working on this for some time, it seems like it should be easy but has proven to stump me. I have a SharePoint list I use to track workplace safety incidents. I have an excel sheet (se...
ganeshsanap
Feb 20, 2021MVP
This is possible using Power automate flow. You need to upload excel file to SharePoint/OneDrive, then you can read the excel rows using Power automate and then update SharePoint list items.
Below references should help you to get started:
- Add & Update Excel Data to SharePoint List using Power Automate
- Update SharePoint List From Excel File
- EXCEL To SharePoint List Through MS Flow
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
SebasthianPersson
Jun 01, 2022Copper Contributor
Hi,
It works if my excel sheet has unique value, but in my case does Column A has the same value, and I need to make it look in booth Column A and B beacuse the combination is unique.
Can someone please help me?
It works if my excel sheet has unique value, but in my case does Column A has the same value, and I need to make it look in booth Column A and B beacuse the combination is unique.
Can someone please help me?