How To Automatically Add Excel Data to a SharePoint List with Power Automate

Using Power Automate we can get the data from an Excel table and automatically add it to a SharePoint list. This flow will check the Excel table every morning and not only add in any new records from the Excel table, but also update and records that were modified on that table.

00:00 - Introduction
00:35 - Preparation: Excel Data in Table Format in OneDrive and SharePoint List Setup
01:26 - Building a Scheduled Cloud Flow in Power Automate
02:32 - Configuring "List Rows Present in Table" for Excel Online for Business
03:50 - Retrieving All Items from the SharePoint List Using "Get Items"
05:03 - Matching Rows and Applying a Loop for Each Row in Power Automate
07:05 - Conditional Check: Update SharePoint List if Row Exists, Create New Item if Not
08:33 - Update Action: Updating Existing Item in SharePoint List
09:53 - Create Action: Creating a New Item in SharePoint List

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#PragmaticWorks

[nikhilmatere]

thank you so much, i reached to the point to figure out to create items in sharepoint and due to the condition being wrong it couldnt update the sharepoint list, this video saved my from getting crazy on the error, mistake i was doing was using the condition as "Not eq to Zero". Thanks a lot for great explaination.

[qww]

Great video. I have a question. If I delete an item in Excel, will that item, or can that item get deleted in the SharePoint List?

[chizuhieida]

THANK YOU!!!! This was so helpful and very clear instruction!!! you da best! <3

[ZeNex]

hopefully this will help me work out how to automate when an email is received to add to an excel sheet in sharepoint or also check and update the cells if required

[monajohnson]

Followed this perfectly. Ran great now I get a message that “an action failed no dependent actions succeeded”.

[WilsonC]

Great tutorial video created. I like how simple and straightforward it is, and it also explains why we did certain things. I would suggest updating the video again if we get the item directly from the excel table with condition, which takes more than 15 minutes to run if the excel table has more than 500 rows with condition. So I think I should convert it into an array to make things easier and faster.

[ericsamboy]

Thank you for this video. Super helpful and easy to follow.

[joannaeland]

This was incredibly helpful, thank you! I am trying to add an Excel table that has over 1000 rows, but it looks like the resulting List only brought in 256 rows. Is there a limit to how many rows we can add to a list?

[carterharris]

This video answered questions not answered by other answers provided by a google search. Namely that one must identify the part of the spreadsheet that is a table to have access to the column names for pairing. Other answers start assuming this selection has already been made. Thanks!

[kennethgottfredsen]

How does this handle missing values in a column? If the user forget to put a value in the status column while creating a new row, is it going to transfer the row with the inserted values and with the blank value in the status column?

[harinijaan]

Extremely helpful. You literally saved me

[Special_Excel_F_and_L]

This seems great. But I am wondering how it runs with multiple rows in the table ? "List rows" is limited to 254 unless you turn on pagination. But not sure how fast it will run then. I have data that is gathered 3 times per day with 87 columns. That make it a big data, may be list isn't the best option but that's what I have available online/sharepoint.

[AronCassell-ko]

Any idea why in the new interface it wont select the correct data, but in the old interface it selects the right information. I.E.,
old designer,

works fine but in new designer selecting the excel items,
Items()?['EXCELINFO']

[chizuhieida]

Do you have video for SharePoint List > Excel?

[nslskdl]

this was extremely helpful. thank you so much

[BigBob]

If a flow is made using the recurring flow, will it add duplicates or know not to add them?

[healthsis]

This is great but what if I have a date field?

[AlonsoParejawee]

Hi! Very useful tips! What if my excel is not in table format? I have a dataset with columns but not in format table. That's how the system pulls in their reports that I want to automatically bulk into a Sharepoint list

[eslamfahmy]

Awesome, but could you share with us share points rules related to the excel file uploaded..like ..

Shall be saved in Doc library

Shall be create a site for that file..etc

[milododds]

What about going the other direction, getting a SharePoint List to update an Excel table? Basically the ability to keep them in synch with each other. Thanks :)