Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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

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.


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,883)