Regular Import of Excel Sheet To SharePoint List 

Please check out the updated version of this Flow here; ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YnuMFnVATuE.html

The "Get Rows" action in the video has recently been renamed to "List rows present in a table".

Who gave you a thumbs down? and man thats a good ratio of likes!

It can't get simpler than this. Like the way you describe each step, it's very helpful.

Hello. Many thanks for your video! very helpful. Is the any way without flow to append new information to existing sharepoint list? structure of the columns are same

Hi Jamie, thanks for the video, it is very clear. I have a column in my Excel sheet called 'RefernceNo' and one in my SP List with the same name. For all the other columns i simply do a map of the fields, but this one always wants 'Dynamic Content'. It was a number field, but i have changed it to text to see if that was it, it wasn't. Any suggestions?

can you help me. I follow your instruction. However when i key in "Exce" my connectors list show the "Excel Online (business)" and "Excel Online (Onedrive)" not showing ""Excel". Thus I can select "Get Row" only instead of "Excel-Get Rows as you demonstrated. Please help to advice

The problem comes when you want to do a nightly run of this file. If you copy over the file you named 'book1" with new data, Power Automate has the file cached and continues to upload the original file and you cannot use dynamic file names with "List rows present in a table". This is basically a manual process of going in a changing the flow every time you want to import new data. Very frustrating.

Do columns titles in Excel have to correspond exactly to SharePoint list titles?

I coudnt implement this....Couldn't find the get rows connector

How to get Table name...in my case It did not show any name?

Hi, very useful. how to fill only rows with data and not empty one? We need that employee fill excel file, and every night the flow will copy the rows and clear it, so the day after it will be blank. And every day there can be a different number of rows.

Anyone tried to get excel data and display in powerapps please reply . I wud like to get excel sheet table and just display in powerapps along with columns . Please reply anyone.

How to transfer data from excel file to SharePoint list if the excel does not have data table with range in it

Thanks!

Any way to do this in SharePoint 2010 ?

Excelente, era lo que necesitaba. Gracias!

Very clever - I'm not sure why you wouldn't delete what was there already as you might end up with duplicates. Personally, I'd be creating a PowerApp over the top of a Sharepoint list versus using Excel and then applying the Flow to that.

Jamie, I am having difficulties with the opposite: exporting a sharepoint list on a regular interval to Excel (or even a CSV file). I was able to Output to csv table only but not finding where to find the file it generated (if it did). How can I do this? thanks.

This Scudule recurrence Template is not Avalible Now, is there any thing similar template to meet same functonality.

How would I be able to get the flow to analyse the contents of any excel file (all same format) that is uploaded to a given folder on SharePoint? The issue I'm facing is I can't tell the flow what information to add to the list since, in the step of "Get File Content", I am using the dynamic content "Identifier" so that it looks at the file that has been added to the folder. Therefore, the flow has no idea of the structure of the file prior to it running, which is why I can't tell it which cell to look at for the information. Any suggestions?

Thanks you, Do you have idea on 1.how to pass Attachment (selected file in powerapps) as an input file in to MS flow, 2. Then Flow has to read the selected input file as attachment please reply

Excellent explanation of flow importing excel to Sharepoint.

Hi Jamie, I was refereed to your video through he PowerApps forum! I'm trying to add some additional functionality to my Powerapp and it was suggested to use flow to achieve this. What you demonstrate is basically what I'm trying to do - except the list I'm attempting to add onto my Sharepoint list is not in a fixed location and is generated on a case by case basis from multiple users. Can you provide me with some help? Thanks~

Great video. If you edit any data in existing rows does this Flow update that data?

Why do this when the Excel sheet is already linked to the SharePoint list and updating incrementally?

Thank you very much, i implemented it

Thank you for nice video of Microsoft Flow use. It's seems to add some actions for avoid duplicate items before day.

Hi. How it will update regularly, everytime updates entire table from excel. ?

What about get rows from business location e.g, fiele stored on SharePoint?

Hello Jamie, when I save the excel file, the excel file continues to say that the file is locked by myself so it's not allowing me to save changes. Any ideas?

Did any one tried for lookup column...?

Hi how do i add updated excel sheet, and then allow SP list to perform auto update on that sheet ?

Hello, is there a limit on the amount of data imported from Excel to ShairePoint list via Flow

How do you import multiple excel sheets with the same tables into the one list?

This was actually very straightforward and very helpful, thanks a lot!

If I follow your steps, when i get to 'get rows' i have to enter a key value. I'm using Excel Business Online. And I have to fill in a lot more variables then you do in your video. Can you help me with that?