Add & Update Excel Data to SharePoint List using Power Automate

This video is about how you can add and update your SharePoint List from Excel Table data using Power Automate. i will fetch the data from excel and then check condition with SharePoint List Item, if data already exist it update the item else it create a new item. watch full video to learn.
apology for Update spell mistake :P

[@jose00033]

This is what I’ve been searching for 🔥 thanks man!!! Please don’t stop posting your knowledge

[@adi0rban]

I used this video to create a SP list which is syncing with an Excel table with 0 Flow experience. Well, maybe not zero, but anyway, very very little, as couldn't understand all the words and had to learn the hard way, by googleing and looking at other sources as well. But in the end, it's simple and does the job. Now I need to start doing something with that list. Thank you for this!

[@LernenTech]

For further queries do WhatsApp message on --> [phone] or mail us to

[@MrBabysillah]

This is Awesome! Thank you for making this tutorial.

[@LernenTech]

Glad it was helpful!

[@ShoebKhan.Official]

Thank you so much, you have explained it so well that I succeeded in first attempt.

[@piacorpuz]

Thank you! Been searching for this for days! Short and precise. :)

[@ryanisjones]

I have followed this tutorial to the letter but it is not creating new items. Only updating the matched one. Is it possible anything has changed since this was uploaded which would stop this from working? Thank you.

[@sheryll9966]

Great vid! Does the raw data have to be stored on OneDrive for SharePoint to know if new data exist on it and will reflect those on the SharePoint list? Thanks!

[@SrikantRZradio]

This is great video . just a humble suggestion to improve this further , Kindly talk little more about get Items columns vs list rows present in table columns . A beginner can easily mix up and not get desired results

[@LernenTech]

Ok, Sure.

[@isBessem]

Old but gold!!! Thanks a million.

[@richg7264]

Great video, I"m just diving into Power automate for work. trying to cut down the number of clicks, copy/paste, and de-duplicate functions on a daily tracker.

[@rozzumar9370]

Thank you so much. This works perfectly for me!

[@LernenTech]

Glad it helped!

[@kuuuyajim]

This is an easy to follow video. I'm just curious if this is going to work with SharePoint even though it's not a List. I guess I'll have to try but if it doesn't work, we'll see if we can transition to the new Microsoft Lists instead. Thank you!

[@DewayneBridges]

Thanks SO MUCH, this really helped get this done!🙂

[@tumuji3167]

This is what I am looking for! 🙏 thx

[@juliovilaca2120]

Just a Quick question, and if the Excel file excluded a row, how can this exclusion be reflected on SP? Great work many thanks

[@MostafaEhab122]

Wonderful Stuff! Thank you for sharing your knowledge!

[@LernenTech]

My pleasure!

[@hizke1]

always short and to the point with great examples !

[@LernenTech]

Glad it was helpful!

[@Samirovisc]

Man, you rock. Thanks a lot for this explanation, amazing

[@thewanderingcouple8378]

Thanks for this wonderful tutorial. It worked, but I had to change get item top count so its working.. I made the top count as 5000

[@nicholashughes8214]

Totally useful thank you for the big assist!

[@rickbartleson5538]

This is exactly what I looked for today for almost 4 hours... and I copied how you did it step by step and worked! My only initial mistake was I grabbed the SP data for each row instead of the table data, but easy fix for a lot of columns :) Thanks for taking the time to do this for us! Do you have one where no matter the file name you can update the same master file? Example - 9 managers post a file into the same folder but all named differently but each has the same content and columns? I am doing a workaround and just copying the logic 9 times and changing the file name in each but pointing to the same list in SP. (SharePoint).

[@LernenTech]

Thanks for writing, please message on our facebook page.

[@narendrakumarpappu6621]

it is not at all working

[@omsingh8765]

Thanks for the useful guide its really helped.

[@Carlog5290]

Thank you so much for the tutorial. It made my life easier.

[@Carlog5290]

Hi, I think there's a limitation. I am copying 50,000 records but it only copied 256 records.. Any thoughts? Thanks.

[@Carlog5290]

It looks like my issue is about the "Flow Run Time" wherein the maximum flow frequency of my flow license is 5 minutes. Is this upgradable?

[@LernenTech]

Glad it helped!

[@LernenTech]

enable pagination and change the limit

[@LernenTech]

will create a video on that soon

[@amycairo2]

Thank you for putting together this video...very helpful

[@LernenTech]

Glad it was helpful!

[@marosa1801]

Thanks for the guide! Does the Excel data have to be formatted as a table in Excel or can it just be rows/columns of data without it being a table?

[@LernenTech]

Yes as table.

[@ofejiroederhi834]

Thanks, great video. I followed steps in video and it worked on first try. Gracias.

[@LernenTech]

Great to hear!

[@ibrahimmaradey3372]

Thanks for this great Class!!!

[@miharold]

I really appreciate your help.

[@shredder5849]

Thank You! Work very good. I have a question. How can I make the list refresh as a donation on the home page? Currently, it is only released in the LISTS tab. And if the list is added as an element on the main page, it only refreshes if I refresh the browser.

[@sebastiandeipenbrock9793]

When I add the "length" formula I get a different formula (length(outputs('Get_items')?['body/value'])) resulting in an error. Any idea?

[@williamlee4809]

I really appreciate you tutorials on this channel. I have found several solutions that work that I have not found elsewhere. I do have a question regarding this flow. I'm using the current version of O 365 and I followed your instructions to the letter. The only difference is that my source is sharepoint not onedirce. However, have a few issues: 1 - When I run the flow all of the entries repeat themselves and have to force to flow to stop after several minutes. 2- I'm unable to create the filter query as there is not a "Title" field in my selections. 3 - The condition results are always true even when I perpusfully duplicate entries to test the update. I look forward to you feedback.

[@tonytseng7780]

Did you ever solve this issue? I'm getting the same error with repeat rows.

[@LernenTech]

I will create same video with updated MS option and keeping your issues in mind as well…sorry for late reply

[@joelleaboytez4030]

@@LernenTech thank you so much for your time and help - this flow will save me so much time and effort! PS - I am not tech savvy at all lol

[@Bren4000]

Great video, thanks for sharing! I would be grateful if you could let us know how to delete items from the list which are no longer in the excel table

[@LernenTech]

For further queries do WhatsApp message on --> [phone] or mail us to

[@shivabkumar7999]

Great work, Prakash. Keep it going. Nice

[@majidkhayal3662]

You are such a prince :))

[@peterjournalism8526]

Hi there, great video! I have a question: When I get to If yes, Update item, I'm only getting the Title Column to fill in (My other columns aren't showing up). Any ideas on what's going on? Thanks!

[@MrMattsimmo]

Fantastic guide, thank you. Just what I was after :). Is there a limit to how many rows you can have in the excel table? I have 50k but when I run the flow it only does 256 items. Thanks.

[@LernenTech]

change flow setting

[@onionman2117]

@@LernenTech I get the same issue, IF I set the top limit to 21000 . It still only does 256 lines.

[@nobrecamarada]

@@onionman2117 I need this solution also. Did you figure out how to do it?

[@fyuksel]

@@nobrecamarada click to three dots to open the menu of "list rows present in a table". Select settings. Turn on paging (the first option). Enter the row count you want to fetch. Save.

[@erlanggasatrioaa7080]

​@@fyukselthis method get the maximum 5000 row from excel, but thank you for advances

[@oluwatobiyusuf]

Thanks for this great video.

[@gamingescape5824]

I tried this however this flow is only adding new row and not updating . I added a row in sharepoint and then modified a column however in excel it is adding new row for modified also instead of just updating the record. also, what needs to be done for deletion of record as if I delete a record from list it should also delete it from excel .

[@teesanfajar8270]

thank you so much, it helps a lot!!! GREAT!

[@LernenTech]

Glad it helped!

[@martingervasoni6939]

muy bueno!! explicas muy bien

[@cvmashu1985]

Many Many thanks for this video :)😇

[@catecorp3171]

Hello! great video, helped me a lot. Just one question, apply what you put, but when creating a new one with data in my table, it doesn't update me, but it doesn't show an error either... the flow runs without problems... I made sure that all the fields passed as text. ..and the list that you create in sharepoint use the "create list from an Excel" option, then I try to update the data and it works, but when creating a new row it doesn't.

[@user-xg6fq8zn5i]

On the "List rows present in table" excel step click the 3 dots, choose settings and enable pagination.

[@nathanbrown1917]

This was really useful. I'm running into one problem though: When I run the workflow, if there are ten lines to be added to the SP List, the workflow produces 100 lines (each line 10 times) even though I have the Top Count set to 1 in the Get Items step. What would cause this?

[@anniekostadinova7915]

I had the same issue and realized that I need to have an extra column on my excel file specific for ID. In my case, I used student numbers and the repetitive lines stopped. Make sure the ID field is not blank. I had N/A on some of the students' # and it was repeating the same name every time the flow run. Hope this helps.

[@lucayi9138]

HI! Nathan, I also got the same problem as yours, Have you take any solution? Can you share to me ? Thanks !

[@paulsauve3691]

Thanks for a great well explained video. I have a perfect application for this, unfortunately, the Update Item step doesn't work. I configure it to update a list column with an Excel value. But when I run it (successfully) no update occurs and when I edit the Update Item step, the Excel value has been changed to a Sharepoint value. Any idea why? Thanks.

[@ericalvo1]

Good video, but a little complex to follow, specially because the options are not exactly the same, I had to replay the video like a million times to get this done.

[@yeahjustlikethat]

Great video! Thank you. What we have attachments, how would that work?

[@LernenTech]

in Excel?

[@MM-cq8jz]

I've followed every step but the list will not update. Any idea or common mistakes ?

[@carlosabella6583]

Thanks... Very useful...

[@LernenTech]

Welcome 😊

[@sininv1]

Hi @Lerne Tech, can you also add in the delete from excel and auto delete in SP list? and also the Date column if it's a DATETIME how to pick up in flow. Thank you.

[@0markaria0]

My exact problem, both of them. Have you solved this?

[@chriscoslett6459]

this is perfect to add date from excel to the sharepoint list....how do i set this flow up to delete are row from the list when i delete it in excel......like update delete?? thanks!!!!

[@hizke1]

THANK YOU ! THANK YOU !

[@chairutsirirut5787]

Nice video. I have a trouble creating item in SharePoint list from a list rows present in a table which is filtered from another list rows present in a table's column. Do you have any suggestion?

[@MrBabuji123]

Awesome video. Works well. except add new item. In my case , it is updating but not appending new data .

[@LernenTech]

it will

[@surangmasharma8159]

Hi, Thanks for creating this video. I just want to know is it possible to only import few columns and not all from excel to SP and if yes can you please guide me to a helpful video of yours.

[@LernenTech]

yes you can! For further queries do WhatsApp on --> [phone]

[@yaosetariasky279]

really helpful!!!!

[@lambo4ever]

Great tutorial but i'm getting some weird behavior. My list isnt pulling through all of the entries. When i look at the entries that havent bene added in flow it reports ActionBranchingConditionNotSatisfied. The execution of template action 'Create_item' skipped: the branching condition for this action is not satisfied. Any ideas?

[@wilfredmanahan]

I also suggest that you update the Pagination to 5000 in the Settings. By default only 256 rows will be retrieved from Excel. Thus updating this will help you when your data grows bigger.

[@nathandounel769]

how do you update the pagination to 5000?

[@MsKAYOMO]

Thank you so much for your video. It works great for me. Can I run the flow if I have only Edit permission?

[@LernenTech]

Yes

[@MsKAYOMO]

@@LernenTech Awesome! Thank you so much!

[@ryanedwards5390]

Great Stuff! I see a few comments below regarding the deletion of an item from the SP list if it is removed from Excel. Have you yet, or will you soon post a video on how to remove items from the SP list that have been removed from excel? or even mark those items as "Removed?" - Thanks!

[@LernenTech]

Not yet!, will post soon.

[@sexyberlam]

@@LernenTech that would be great!

[@joejoesto]

@@LernenTech ok where is the video tutorial

[@user-gt9rg3ql4e]

This video is exactly what ive been looking for!! followed step by step but unfortunately my run failed but as not a whiz with technology i am unsure how to rectify it! this video is create but is pretty fast. any help would be massively appreciated!

[@LernenTech]

plese drop an email

[@AnthroSarkis]

Thank you!!

[@LernenTech]

You're welcome!

[@RowDogSA]

Thanks. If I add new rows in Excel e.g. Employee 6 and Employee 7, will it add them to the Sharepoint list? Also, if I delete an Employee in Excel, will it delete the employee in SharePoint? I can see this working with a condition checking a column called "Employment Status" whether the employee is "Active" or "Inactive". Would love a tutorial on this.

[@LernenTech]

Sure will try.

[@ashvinsaini01]

Hi, thank you for valuable video. Can we add ms form excel attachement data on another excel file which stored in SharePoint.

[@LernenTech]

not sure what you are looking for?

[@LilMissMagnolia]

Hi thank you so much for making this tutorial! I am successfully uploading entries from my excel table to my SharePoint list and updating entries. However, I am getting duplicate entries in my Sharepoint list. Do you have any suggestions on where I went wrong and how to fix this?

[@LernenTech]

Do a WhatsApp message on - [phone].

[@memoparra851]

@@LernenTech I have the same problem on duplicates, what is the solution please?

[@jackdavis874]

This video is a god-send

[@AnuarKZAst]

Hi, thank you for your tutorial. I saved my file in sharepoint and named table as you said, but when I created flow with "List rows present in a Table" and linked the EXCEL file it cannot find the table. Could you please help ? What could be the reason?

[@LernenTech]

For further questions and queries mail us to [e-mail] or drop a message to our Facebook page - facebook.com/Lernentech/

[@Dakshu_Talks]

Pls let me know what is best approach for adding data to list without third party tool

[@bryankendig3989]

Are there any changes required if the excel file from which data must be taken is hosted by Sharepoint rather than OneDrive?

[@slumpig69]

Hiya. Thanks for the video. I'm having issues with the last step. My other column headers not including Title don't show up in the dynamic content window. For 'Title' they al appear but when I clock into another column box to match them up there is nothing from the 'List rows present in table'. Any ideas? Thanks

[@LernenTech]

check latest video in channel

[@anwarkrg9292]

Hi, thanks for sharing. I have a daily schedule download excel file where it automatically saved to sharepoint folder. I would like to add a unique column in this excel file, rename and save it and connect it to another excel file every time a new file added to the folder. How to automate this flow in Power Automate? appreciate your help.

[@justrhuna2263]

Thank you 🥰🥰

[@danyell12345]

how to i edit this flow if i want it to check for updates throughout each cell in the excell sheet and to overwrite old data and update new???

[@GarthShaner]

This is EXACTLY what I needed for an issue we were trying to solve. My only problem is I have 285 rows in my Excel table, but the flow stops at 256. Any ideas why that happens?

[@LernenTech]

change the pagination setting you will be good.

[@ironkaicer]

@@LernenTech Sorry where can i change this? Because my sp list its open, but its the flow that it stops

[@partloch]

Good video, helped. Is there one for deleting duplicate items in a SP List?

[@LernenTech]

Not yet

[@0markaria0]

@@LernenTech Is there one now?

[@raivolution]

Hi how would you delete rows that have been removed from the original excel but still exist in SharePoint?

[@srividhyapks9869]

wooo... Thank You its working..

[@LernenTech]

Enjoy

[@no.more.official]

thank you

[@biosrmarun]

Hi Sir, so thankful for your lesson when i tried i am getting the below error not sure what is the problem but i am get data updated in the list after that the flow has been failed "Unable to process template language expressions for action 'Condition' at line '1' and column '24757': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'".

[@LernenTech]

For further queries do Whatsapp message on --> [phone] or mail us to [e-mail] or drop a message to our Facebook page - facebook.com/Lernentech/

[@sophiago5954]

Thank you for this video! I tried replicating this flow but only the update item works for me, it doesnt create a new item although there's a checkmark when the flow runs. I wonder why my new items arent appearing, would you have any theories?

[@LernenTech]

new video is soon

[@seemahemant8070]

will it work if my excel has more than 5000 rows? Even if I change settings of my "List rows present in Table", the max I can go for is 5000.

[@dcm9058]

Hi, is it possible to create a Flow that whenever a new row or record is created or added into an excel file the Flow automatically creates a new item in SharePoint? Thanks

[@LernenTech]

well i am not sure about that. i will have to see that as there is no as such trigger option we have as of now i guess.

[@arvind_ch]

Can you pls help..I want to use MS form for filling the data, then needs to get approval using power automate..once approved it should save the data in Excel with approver name and also his comments..thanks

[@memoparra851]

It works thanks! only have one problem if I include a Date format cell I get OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/PublishingDate' is required to be of type 'String/date-time'. The runtime value '"43938"' to be converted doesn't have the expected format 'String/date-time'. Any Idea

[@LernenTech]

For further queries do Whatsapp message on --> [phone] or mail us to [e-mail] or drop a message to our Facebook page - facebook.com/Lernentech/

[@sininv1]

Hi Lernen, are you able to teach how to delete too? Thanks

[@johanvandyk6532]

Do you perhaps have an example where a Document Library metadata is updated from an Excel file?

[@albenjr]

Awesome it works perfectly!!!!! but it only lets me import/ update 256 registries :( and my Excel has more than 1500 rows. Any recomendations from your expirience??

[@LernenTech]

check out my other video

[@munfordable]

try this. hit the "..." next to list rows in table and settings then change threshold to whatever

[@bunyaminozcan2429]

Goodday, Thank you for the guide on the flow! I tried implementing this solution but I want to import date format data from Excel to list. Somehow this does not work, resulting in an error that it cant convert it. Have you tried this with dates?

[@LernenTech]

Video is coming in next 1 or 2 days.

[@bunyaminozcan2429]

@@LernenTech Thank you! I will be on watch for it!

[@whitneymeyer5546]

@@LernenTech Have you posted the video yet? Struggling to convert dates!

[@matthewwaldron5488]

I have a few questions that I am having difficultly finding the answers to... 1) Is it possible to set up a logic that prevents the flow from pulling over duplicate information? 2) Can you set it up where it will not pull over information without a specific cell in a row being filled out? 3) One of the cells I want to pull over has a date, but when it pulls to the SharePoint list, it converts the date to a number, and when I set up the column to be formatted as a date, it prevents the flow from running because Excel is exporting the number, not the date. How can I have the date transfer over?

[@LernenTech]

For further queries do Whatsapp message on --> [phone] or mail us to [e-mail] or drop a message to our Facebook page - facebook.com/Lernentech/

[@KATERINEJULIO-ko3lm]

@@LernenTech Hello there, I'm experiencing an issue with duplicate values in my SharePoint list despite using an ID column in both the SharePoint list and Excel file. I've tried running the flow multiple times, but the problem persists. Additionally, I've attempted to connect through WSP and Facebook but haven't received a response. Could you please assist me with this issue? Thank you

[@ravinduudayanga2522]

Thanks mate

[@LernenTech]

No worries

[@paulsinner890]

Does this also work with document libraries?

[@mat6997]

Hello, can you create a video on how to Delete Items on Excel File when Items on the SharePoint list gets deleted? Do this without using the "When Items get Deleted" trigger and use a recurrence action?

[@COZY_MONEYX]

Hi can you help on capturing data in Excel once excel file is created in SharePoint with column name as file name, date and month and finally the name created.

[@dcm9058]

Hi Lernen Tech :), i tried using this Flow and twas nice but then it is sending multiple emails everytime i change something in the excel file...i mean is there a flow that would send an email only once the excel file has been closed? so that the email is sent only once. Thanks!

[@LernenTech]

For further questions and queries mail us to [e-mail] or drop a message to our Facebook page - facebook.com/Lernentech/ or do a Whatsapp message on - [phone]

[@Maverick-uw1nc]

Thanks for the video. what if the data is deleted from the excel. Could you help with that as well

[@LernenTech]

will see

[@jonfinleyltr]

@@LernenTech Any update on how to deleted data?

[@arnabmit]

Awesome! How do I do this if my Excel file is in SharePoint library, instead of OneDrive?

[@sheryll9966]

I have a similar question. :) I wonder if it should just be on OneDrive for the file and the list to communicate properly.

[@Bren4000]

In the "List rows present in a table" step (step 2) you can specify the location as your sharepoint site

[@ppetrix]

Thank you

[@LernenTech]

Welcome!

[@zimands5]

would this method work, if I just wanted to update a small number of items from a sharepoint list? example: i have a list of 100 items, but only about 10 need to be updated. So the excel data has only 10 lines. Will the filter query work to just select the 10 items from the sharepoint list that i want to update, and leave the other 90 alone?

[@LernenTech]

It should

[@markburrage8945]

Hi, thank you for this it is brilliant. I am having trouble as it keeps running indefinitely (7hours so far) and does not seem to update the list but does not show any failure.

[@LernenTech]

check the latest one in channel

[@VIKRANTSINGH1991]

It seems it's not possible between Excel and SharePoint 2016 update, via Power Automate. Any help would be appreciated.

[@robertosebastiancastillope5858]

Hi, Thanks for the information. I have a problem , I used it with a table with more columns and more than 1000 rows , it ran correctly but it only added 256 rows, and I would like to know the problem.

[@LernenTech]

change your flow setting, there is a video in channel for that.

[@robertosebastiancastillope5858]

@@LernenTech Thanks!

[@zimands5]

in my excel table, i have some fields that have dates in them. The dates come in to sharepoint as numbers like 45341, etc. I know how to convert excel dates to sharepoint dates using an expression like: addDays('1899-12-30',int(item()?['DateField']),'MM.dd.yyyy'), but I don't see where i would use that in this flow, because i don't think the item() is exposed like that. Do you have some advice on how i could integrate a date conversion into this flow? I have tried several things and none of them have worked yet. Maybe i have to do the update as shown, and then iterate through my SP list a second time doing the conversion?

[@LernenTech]

will create updated version of this and cover your point there.

[@BenVinar]

@@LernenTech Hello, just checking in to see if you can help on this! I too am facing the same issue

[@LernenTech]

@@BenVinar kzbin.info/www/bejne/g6WmopWId7SCmJY