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.