I have 300 folders in SharePoint for each vendor. Each month I will generate 300 pdf invoices and have to upload them into each specific folder. I want to avoid manually uploading each invoice to 300 different folders. Is there a way to automate this?
The folders are named the name of the vendor. Each folder contains a column for their "ILV" number. The ILV number is also included in the name of the pdf that will be uploaded. So I was thinking maybe there is a way to problematically add the pdf to the correct folder via the vendor ILV number. But I am new to SharePoint and programming and I do not really know how to get started.
Ex. Folder Name: Test Company Document to Upload Name: 2020Jan--ILV0834 ILV: ILV0834