Appending Excel Table Data to SharePoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-215610%22%20slang%3D%22en-US%22%3EAppending%20Excel%20Table%20Data%20to%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215610%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20it%20possible%20to%20use%20Flow%20or%20some%20other%20process%20to%20append%20data%20from%20an%20Excel%20Table%20to%20a%20SharePoint%20list%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%20each%20period%20a%20new%20Excel%20file%20will%20be%20saved%20to%20a%20SharePoint%20Folder%20and%20I%20would%20like%20to%20then%20automate%20the%20process%20to%20take%20the%20data%20from%20the%20table%20in%20that%20file%20and%20append%20it%20to%20an%20ever-increasing%20SharePoint%20list.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWyn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-215610%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-288580%22%20slang%3D%22en-US%22%3ERe%3A%20Appending%20Excel%20Table%20Data%20to%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288580%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20explain%20how%20this%20works%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20Excel%20file%20sitting%20on%20Sharepoint%2C%20containing%20a%20table%20which%20has%20been%20exported%20as%20a%20sharepoint%20list.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20the%20list%20to%20be%20updated%20whenever%20I%20change%20source%20data%20in%20the%20excel%20file..%20How%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20878px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F60221iADFE968C5DA8ADDD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222018-11-18_17-59-40.jpg%22%20title%3D%222018-11-18_17-59-40.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-215766%22%20slang%3D%22en-US%22%3ERe%3A%20Appending%20Excel%20Table%20Data%20to%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215766%22%20slang%3D%22en-US%22%3EHave%20not%20checked%20Flow%20possibilities%20here%2C%20but%20this%20scenario%20can%20be%20achieved%20with%20an%20Azure%20Function%20that%20is%20monitoring%20the%20Excel%20file%20to%20check%20if%20there%20are%20new%20updates%20and%20when%20there%20are%2C%20just%20update%20the%20list%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1094375%22%20slang%3D%22en-US%22%3ERe%3A%20Appending%20Excel%20Table%20Data%20to%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1094375%22%20slang%3D%22en-US%22%3E%3CP%3EUse%20timer%20job%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93050%22%20target%3D%22_blank%22%3E%40Christoffer%20Risberg%20M%C3%BCller%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
MVP

Hi 

 

Is it possible to use Flow or some other process to append data from an Excel Table to a SharePoint list?

 

So each period a new Excel file will be saved to a SharePoint Folder and I would like to then automate the process to take the data from the table in that file and append it to an ever-increasing SharePoint list.

 

Thanks

 

Wyn

3 Replies
Have not checked Flow possibilities here, but this scenario can be achieved with an Azure Function that is monitoring the Excel file to check if there are new updates and when there are, just update the list

Hi,

 

Can you explain how this works?

 

I have an Excel file sitting on Sharepoint, containing a table which has been exported as a sharepoint list. 

I want the list to be updated whenever I change source data in the excel file.. How?

2018-11-18_17-59-40.jpg