Power Platform Community Forum Thread Details

Hi, I have a scenario in which I need to handle the situation if the PDF file is partially readable, these pdf are scanned documents, i need to send an email if these are partially readable and we are not able to extract all 8 values from this.

But i am facing issue for partially readable pdf.

I am reading the pdf using the AI model to read data from pdf based upon the position of the values in the PDF

in the above test file snap for one of the values, in general scenario this is an 8 digit number instead of pink color, and in this case i am reading this pink color it should give me blank or null , but it is reading the text data next to pink color.

So it is giving me some nearest random data instead of blank in case of partially readable pdf is present.

We are then writing these extracted detail into an Excel file having columns like

Number1 number2 ... etc

Value value

So how do i handle this issue, to send email in case it is reading wrong data , like if i can add data type check on excel column in power automate, like Number1 column should be having numerical values, but in that case it might read some nearest random numerical value and pass the test, which it shouldn't.

some columns are Date column, some are textual and some are numeric type columns.