Automate creation of files
Budget: $10 – $30 USD
I have a Sharepoint List with PDF files, these PDF files might be updated or there might be new files uploaded. The Automate flow should start on both of these occasions.
When a file is uploaded, the filename will start with 8 numbers, this number should be compared to a table in a spreadsheet.
The spreadsheet table has 6 columns and a few thousand rows, the Sharepoint documents library will consist of a few hundred documents - all will have a number in the filename which corresponds with a row in the Excel sheet.
If the corresponding number is found, I want to copy the new/updated file in the sharepoint library and use some of the information in the corresponding excel row to make the filename of the new file, there could be multiple identical files copied but they need to have different filenames based on identified rows in the table.
When a file is uploaded, the filename will start with 8 numbers, this number should be compared to a table in a spreadsheet.
The spreadsheet table has 6 columns and a few thousand rows, the Sharepoint documents library will consist of a few hundred documents - all will have a number in the filename which corresponds with a row in the Excel sheet.
If the corresponding number is found, I want to copy the new/updated file in the sharepoint library and use some of the information in the corresponding excel row to make the filename of the new file, there could be multiple identical files copied but they need to have different filenames based on identified rows in the table.