Hi everyone,
I need to rename several PDF files that are on SharePoint. There may be more than 300 files in total.
Each PDF comes with a number called a NOTE. Each one has an identification name: 90304055, 90704066...
Each NOTE has a corresponding ORDER. So, if 90304055 is order 10406699, and so on...
This data is in an Excel spreadsheet. There are columns for NOTE and ORDER. I need the files to be renamed according to the ORDER numbers corresponding to each NOTE.
This automation needs to be done within SharePoint, as the files are there. Therefore, I need to rename several PDF documents in SharePoint using an Excel spreadsheet and Power Automate.
I tried to move the file. I tried to use the HTTP request. Options like get file content, get file metadata and get files (properties only).
These are always failing, even with the correct website address. Well, I've reached a point where I don't know what to do anymore.
Can you help me, please?