Copy the filename in Excel for every file uploaded in SharePoint

(0) Share

Report

Posted on by Community Power Pla...

Hi! Is there a way to copy the filename in an online excel file (macro enabled) every time a pdf file is uploaded in a SharePoint folder? Thank you in advance!!

Categories:

Process Advisor

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Copy the filename in Excel for every file uploaded in SharePoint

thank you!!!
Verified answer

mahoneypat 1,720 on at

Like (0)

Report

Re: Copy the filename in Excel for every file uploaded in SharePoint

You can use a Flow like this to do that. First, create an Excel file with a Table in it (I called mine tblFileNames in example below) to store your filenames, and put in on SharePoint. Then make a Flow that triggers off when a file is created in that SharePoint document library, and add an Action to add a row into the table in the Excel file you made. Use the filename to populate the desired column in the Excel table.

Regards,
Pat