I need to bulk upload revised documents (around 5000) to SharePoint. We don't have Premium so, no access to HTTP. I divided my task into 4 Flows.
Flow 1 - Check out the documents.
Flow 2 - Used a work around to create the revised file. I retrieved the existing file and replaced content from the new file.
Now at this point the document is checked out and existing metadata is cleared.
Flow 3 - Update Metadata. What I thought would be the easiest part is now proving to be the most dfficult one. I have the new metadata in an Excel file. Ihtought it would be a simple matter to retrieve the file ID based on the Name (the Names in the Excel Files and in the library are identical) using Get File (Properties only). But Get File Properties does not work because there is no metadata and it is encountering an error value. I know I can continue on after Flow 2 using the same ID, but for error control purposes we do not want to.
The Update Metadata flow is ready and I have tested it usingthe numnerical ID of a file. The challenge I am facing is in getting the ID. I have tried my best for 2 continuous days now, but have not been able to find a solution.
Can anyone help and tell me how I can get the ID without using Get file (properties only)? I will be very grateful.
"In Power Automate, the SharePoint Send HTTP Request flow action lets you construct and execute SharePoint REST API queries. This action is particularly useful in cases where the existing SharePoint flow actions do not handle your requirements, or the action you are looking for is not yet available in the SharePoint connector."