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

[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

[jose]

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

[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.

[adirban]

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!

[ShoebKhan.Official]

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

[juliovilaca]

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

[richg]

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.

[thewanderingcouple]

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

[ofejiroederhi]

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

[rickbartleson]

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).

[piacorpuz]

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

[paulsauve]

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.

[williamlee]

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.

[gamingescape]

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 .

[shivabkumar]

Great work, Prakash. Keep it going. Nice

[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!

[ryanedwards]

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!

[MM-cqjz]

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

[sebastiandeipenbrock]

When I add the "length" formula I get a different formula resulting in an error. Any idea?

[ericalvo]

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.