How to Import Excel Data to SharePoint List using Power Automate / MS Flow

This video is about how you can Import/Copy your Excel Sheet Data to SharePoint List using Power Automate or MS Flow. your excel sheet should be in either on your OneDrive or in your some of the Document Library. watch full video to learn how you can achieve this.

[jesselopez]

Hi, I got this to work, thank you for that. But my goal is to append data into the SharePoint list. Meaning that I need to upload from the same excel file to SharePoint (different data each time). I need to be able to clear the excel file, add the new data, upload that data to the list (append). Ideally, I would need it to avoid duplicates as well. Much appreciated!

[tlmsbqn]

Nice work. You got appreciation from my Manager. Thank You!

[educampos]

You made win a compliment from my boss. Thank you!

[harshmishra]

Where the link 🔗 for part 2 where you said it would not copy the repeated items

[amandavalentims]

Thank you so much for this! It's exactly what i was looking for

[emanuelmiranda]

thanks so much!!! greetings from Argentina.

[marioscarabelli]

hey, thanks for the video which helped me a lot. could you maybe share the link to the video which covers the date issue?

[laedays]

Is there a way to do this by getting the recent excel file (based on the latest date) in a particular sharepoint list folder?

[SARAVANANVPPS]

This is simple stuff. Need to know for person field with error handling if user is not there in sharepoint.

[mridulgrover]

Hi, Thank you for this video.. it saved me literally.. but could you please help me.. if I have multiple emails which I want to copy, how can I do that.. I am trying by adding a semi colon but it doesn’t seem to be working.. single email is working

[manirathinam]

Hi.. I need your help.. Like in my case I have one excel sheet where I'll have multiple columns of data.. I want to pick the n number of data from one column for ex name it as ID.. and I want compare this ID data with my SharePoint data.. In SharePoint also I'll have multiple columns of data where I will have ID column there also.. Basically I want to compare the ID column data from Excel with SharePoint ID data.. can you please let me know how we can do this

[BoyTukaness]

Hi, how do you change it to automatically? what would be the trigger then? thanks mate

[beenasharma]

My table contains 10167 items but the flow runs forever and I had to cancel it manually, Moreever this flow just picked first 64 items from excel and keep adding the same again and again in list. Appreciate your suggestion what I am missing?

[lonnix]

Thanks man. It really saved me the day.

[hryhry]

Is it possible to export from multiple Excel files containing identical tables into a single SharePoint list? The multiple Excel files are located inside a same SharePoint folder

[luizfelipemoraes]

Hi, Thanks for the video. How can I export only 1 data to the list? Example: I want to parse all columns/rows and export only 1 data that contains "Free"

[fahadhussenshaik]

How to load CSV file into SharePoint list, CSV file is in local system, pls suggest
Thanks

[DeepDeep-zdjq]

Nice video. In my scenario I'm getting data from Excel one of my column data is number format but in ms flow it showing as string and give error while I'm subtract this data with other integer. Could you help me on this..

[gayathrij]

I have created a flow but it fails when the excel file have blank values for the columns formatted as Number and Date in the share point list. Please help me regarding this issue.

[Manojkumar-ihdt]

Hi, i tried the same in dataverse but getting error on passing the choice field column. Does the format needs to be changed on excel? Can you help me on this.