Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

How to handle partially readable PDF in Power Automate

(0) ShareShare
ReportReport
Posted on by

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

SushantSharma18_0-1668664688331.png

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. 

SushantSharma18_1-1668665160179.png

 

 

  • Re: How to handle partially readable PDF in Power Automate

    Hello All,

     

    I am also facing same issue as sushant W.R.T power automate OCR functionality unable to read blank data if data is not present for particular position,it is giving nearest matched text but that is not needed.so in image,, particular position is empty then it should provide empty as a result.

    Can someone help me with this issue .

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard