Forum Discussion
Update SharePoint list with Excel Items
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.
- 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? I created a flow to update and create item from excel to share point but the flow fails for the Number formatted columns if the excel have blank values. please help regarding this issue.
Gayathri_Reddy a quick fix would be to set the column type as single/ multiple lines of text instead of number. You can format the data afterwards per your use case.
Hi - Does this work for columns that are multiple-choice? Or is this best for columns that are single/multi-line text boxes?
