Forum Discussion

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jul 14, 2018

Appending Excel Table Data to SharePoint List

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

Microsoft Flow
SharePoint
  • jcgonzalezmartin's avatar
    jcgonzalezmartin
    MVP
    Jul 15, 2018
    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
    • Christoffer Risberg Müller's avatar
      Christoffer Risberg Müller
      Copper Contributor
      Nov 19, 2018

      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?

       

       

Resources