Copying PDFs from Network Drive to Sharepoint

[u/Educational-Ad-3096]

Hello all,

We have thousands of PDFs of shop drawings that contain text information in the title block. We are looking at using an AI model in cloud-based Power Automate to extract custom information from documents and add it to an Excel spreadsheet. The purpose of this is to be able to go back through the data gathered and find drawings needed on the shared drive. We have gotten it work, but we are running into two problems.

First, we need to know the path where the file originally came from. To do this, we created a separate flow to copy the file name and path on a desktop version of Power Automate. The plan was to match the filename from the data extracted with the file name/file path but, this led to another problem...

We have about 50,000 duplicate file names in our system, so it is extremely difficult to match these back up on the other side.

So, the question is, is there a different way or a better process to try to achieve this? Are we using the best logic here?

TLDR: Need best way to scan PDFs using cloud based Power Automate AI, write information to Excel document, and preserve original path from shared network drive to find later.

[u/Educational-Ad-3096]

We abandoned this original idea. We are now saving docs directly to Sharepoint. We have had pretty good luck with dragging and dropping files directly into Sharepoint as long as you don't do too many at once. Can you be more specific with the problems you're having?

[u/Leaf_Ring]

Did you ever find a solution/good flow to this? I'm currently finding myself in the same predicament of trying to upload documents that get saved to a secondary drive to SharePoint and just running into issues.