Extract Laboratory Results to LIMS

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.

Related

• Power Automate and creating text with GPT using a prompt