Append new excel tables frequently uploaded to a folder onto sharepoint list

(0) Share

Report

Posted on by Deepaksavanur

Hello All,

I have new files coming in to a folder in SharePoint every 3- 4 days and these tables have different name which is equivalent to most of the names in a sharepoint list that I want to get updated using this files.

1) I have set a trigger to the sharepoint folder if there is any change in properties

2) It checks if the file is an xlsx file to avoid failures due to pdf files which will also be uploaded to the same folder

3) get tables from the file that is being uploaded

4) update items on sharepoint list

Currently I am stuck in this step where update item shows all the columns of the SP list but I don't know how to define this custom names (example: ID (pdf document) in SP list would be unique ID in the new uploaded file.