Hi @J604 ,
You can try the below solution in Cloud flow.
1.Trigger: "When a file is created (properties only)" trigger.
Settings:
Set the "Folder Path" to the server drive location where your PDF reports are downloaded.
Choose "PDF" for the "File type filter" (optional, to only trigger on PDFs).
2.Action 1: "Get file content (OneDrive for Business)" action.
Set the "File Identifier" to the dynamic content from the trigger - "File Path". This retrieves the content of the new PDF.
3.Action 2: "Convert to table (Excel Online (Business))" action.
Paste the dynamic content from Action 1 (PDF content) into the "Content" field.
Choose the appropriate delimiter and other options to format your table as needed (experiment with a sample PDF to get the best settings).
4.Action 3: "Create file (OneDrive for Business)" action.
Set the "Folder Path" to the same server drive location as your PDFs.
Set the "File Name" to something descriptive, including the date or using dynamic content from the trigger (e.g., "Report_YYYY-MM-DD.xlsx").
Paste the dynamic content from Action 2 (converted table) into the "File Content" field.
5.Action 4 (Optional): "Delete file (OneDrive for Business)" action (to delete the original PDF).
Set the "File Path" to the dynamic content from the trigger - "File Path".
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
