Add & Update Excel Data to SharePoint List using Power Automate | Excel Import using flow

This video is a step-by-step tutorial on how to add and update your SharePoint list items from Excel Table data using Power Automate flows.
We will create a template Excel file, where data to be imported to SharePoint will be loaded. The Template file will be made available for download from SharePoint Library (or OneDrive). Excel files with data rows will be uploaded to a SharePoint drop off library where Power Automate flow will be listening to start adding or updating the data from the Excel file (Table with rows) to SharePoint List.
Flow will track the status of the Excel file, Log updates & perform error handling, add & update SharePoint list data for most column types - Text, Date, Date & Time, Choice, Lookup, Person, Multi select choice, multi select person columns & more.
We will also look at getting lookup column ID from secondary SharePoint List.

Flow will check if row in Excel has an existing item in SharePoint. If yes, then flow will update SharePoint item from Excel row data else flow will create a New Item in SharePoint List.

This Power Apps Video covers the following:
✅ SharePoint List
✅ Excel Template from SharePoint List
✅ Add Excel data to SharePoint List using Power Automate
✅ Update Excel data to SharePoint List using Power Automate
✅ Add data validation & null checks in Excel & flow
✅ Date and time conversions
✅ Excel file import status logging & more.
✅ Performance & Limitations for large excel files with large number of rows, 256 row limits, pagination, 6 minutes delay for locked file status & more.

🔗 Download ⬇️ Sample flows

🔗 List rows present in a table (Excel Connector)

🔗 SharePoint connector

🔗 Power Automate flow Expressions Tutorial

Table of Contents:
0:00 - Introduction to Add & Update Excel Table data to SharePoint using flow
0:47 - SharePoint List Scenario
2:08 - Import Excel data to SharePoint
2:41 - Create the Excel template file to Import to SharePoint
7:19 - Excel Data Validations
8:35 - Create Power Automate flow to add Excel Table rows to SharePoint List
24:33 - Add Null Checks in Flow
26:41 - SharePoint Date & Time Columns - Time Zone Conversions
29:25- Limitations & Performance for large data in Excel
32:27 - Update Excel File Status (file locked scenario when List Rows present in a Table action is called in flow)
35:51 - Add logic in flow to update SharePoint List data from excel file.
40:04 - Log results of Excel file import to SharePoint using Power Automate
41:42 - Subscribe to Reza Dorrani channel

#PowerAutomate #Excel #SharePoint #ExcelImport #SharePointList #Flow #MicrosoftFlow

🤝 Let’s connect on social:

[amigomusa]

I will be the first to comment, haven't even watched the video yet. Confident that you always come through with the best step-by-step guided tutorials on the Power platform. 😀...

[manishh]

Absolutely phenomenal. I was building a flow to talk directly to Salesforce via their premium connector but it was such a heavy operation (s) to get all the values, etc. Then realised I could use Excel to talk to a preconfigured report in sales force which would give me the values I needed without multiple lookups and then to use this file to update SharePoint. Your video could not have been posted at such an appropriate time. It's gonna save me days of figuring out stuff. And I learnt so many new things.

You are a genius and I thank you for sharing your knowledge to bring the rest of us (ok I am referring to myself) to about 5% of your level !

[chrysarreola]

You and Shane young are basically carrying my career on your backs

[luistapasco]

II spent several days and several videos trying to find the solution to my problem and with you, no matter how long the video was, I managed to get my flow working. I really appreciate the time you spent explaining this task so well, thank you so much.

[dhofstra]

Thank you very much for this video, excellent work! I have a large excel file (4000+ rows) that would have taken several hours for this exact method to update every row each day. In my scenario, only a few dozen cells change each day in the Excel Spreadsheet, so not every one of the 4000+ rows really needed to update each day.

As a solution, I created a Data connection in my Excel file which pulls down the SP List. Then I created 3 Merges in PowerQuery for Excel, which produced 3 separate Tables. One table contains items that need to be "Added to Sharepoint", another table contains items that need to be "Deleted from Sharepoint", and the 3rd table contains items which need to be "Updated in Sharepoint". From there I used the concepts in Reza's video to create 3 parallel branches of "Apply to Each" in PowerAutomate: "Create item", "Update Item", and "Delete Item". Only updating the rows where a change has been made has worked flawlessly and only takes about 4 minutes to run each day.

[tomseymore]

A lot to digest, but *extremely* helpful, thank you! I learned quite a bit in one sitting. I will have to play & pause to get some details right, but you have paced this in such a way that won't be as difficult to do. Thanks again for taking the time to create this.

[CloudhoundCoUk]

The video covers complex processes. Will require a number of views to even begin to grasp the subject matter covered. But if you are serious about automation this is a MUST VIEW video. Thank you Reza. Keep up the good work.

[PixSmith]

This is really one of the most helpful tutorials on Sharepoint that I have seen. Thanks for all the incremental steps as well. It helps to prevent issues in my particular case, and I appreciate the clarity and excellent teaching.

[bobthewobbly]

It's always the best when I google a very specific scenario and a video from Reza documenting exactly what I'm trying to do pops up.

[akashkaushik]

Hi Rezza...thank you for posting this video. Creating the flow proved to be so efficient in inserting over 4000 rows of data from a spreadsheet to a list in SPO. Keep up the good work.

[UCanDoItMike]

Extremely well organized lesson. Straight to the point and well articulated. Thank you for sharing.

[mrCetus]

That magic of video editing that you do not have wait for delay action to finish running. BTW in my test tenant update file properties 2 action after 6 minutes delay ended with 400 error. Icreased the delay up to 10 minutes, flow ran successfully. Thanks for sharing 🙏👍

[akashnet]

This is really great. Could you please create a seperate complete video around error handling. That would be really helpful.
Once again thank you for sharing your knowledge.

[WillCooper]

Extremely useful information. This is something that is needed in many scenarios for solutions built in SharePoint. There are some tricky things to address when moving the data. Thanks!

[CheapCheerful]

Reza, you are the Power Automate / Power Apps KING!

[culebradiver]

Saved my butt again Reza... quick, concise, spot-on help. You Rock!

[johanvandyk]

Awesome, have been looking for a good example and this one is great!!

[rupatron]

Reza, big Thank you for what you do and teach, I really appreciate it. You are a great and expert trainer.

[franknielsen]

Lookup columns is hard work. Thx for the great walk-through 👏👏👏👏

[akshaynm]

Really a gem Reza. Though it looks like a very simple and easy topic, I experienced that it is really very complex activity to import data from Excel to SP List. You have explained very complex part like adding multiselect choice fields, multiselect person field, date and time field with the classic workaround are really great. This I would say you demonstrated a complete solution all together. Thanks a lot as always 🙏🏻