Solution to automate the import of test results (PDF files) into the Laboratory Information Management System (LIMS):
- Test results arrive as email attachments in PDF format.
- The documents may be written in either English or Chinese.
- Although the PDF files adhere to a fixed layout, the test result rows are challenging to parse programmatically.
- Each test result must be mapped to the corresponding LIMS code.
Solution
- Using Power Automate and a custom prompt, we extract the required information from the PDF document. The prompt receives the current LIMS codes as a parameter and matches the test result rows to the corresponding LIMS code.
- If the LLM is uncertain about a match, it marks the test item’s LIMS code as “unknown.”
- The user then reviews the LIMS code mappings and fills in any missing ones.
- This review process is done through a custom page embedded in a model-driven app.