Skip to main content

Notifications

Power Apps - AI Builder
Unanswered

Form Processing & Text Recognition For Table Extraction Issues

(0) ShareShare
ReportReport
Posted on by 2

Hello to whom this may concern,

 

I have made a form processing model to scrape data items from a pdf invoice using the form processing model. For my model, while creating the model the confidence of 100 % was displayed, and no values where skipped, however when I parse those values in my flow values are being skipped in no specific order and this is occurring with multiple pdfs that the model was specifically trained to.  My second approach was to extract the whole table as a whole instead of column-wise and this extraction as a table was rather more inconsistent then column-wise extraction values where being skipped characters were being rude as different values and etc. 

 

Any Solutions to get rid of the inconsistency since whole data items are being skipped, just a reminder the invoices for these models are high quality.

 

Assuming this is an AI Builder issue for fetching data from table? Please advise your opinion and potential solution.

 

Thanks in Advance.

 

 

 

Categories:
  • JoeF-MSFT Profile Picture
    JoeF-MSFT on at
    Re: Form Processing & Text Recognition For Table Extraction Issues

    Thanks @AaiyanVirji for verifying. 

     

    In your flow, have you selected the table items that finish by value? In my following example I have a table like this:

    Item Quantity Rate Amount
    Monthly service fee 1 $40.00 $40.00
    Add-on services 2 $6.00 $12.00


    So to iterate each item in flow I select, table_0 Item value, table_0 Quantity value, table_0 Rate value and table_0 Amount value.

    2020-06-10_23-09-26.png

     

    When I select one of the items, the action where I add any of these values gets added automatically to an Apply to each loop.

    2020-06-10_23-09-36.png

  • AaiyanVirji Profile Picture
    AaiyanVirji 2 on at
    Re: Form Processing & Text Recognition For Table Extraction Issues

    I have done that, and the values are coming up just the same when I test the model but, when I try to parse the data it fails to get all values and all values have been enclosed by rectangle meaning they are being fetched by the model hence not sure why the values aren't all being parsed.

  • JoeF-MSFT Profile Picture
    JoeF-MSFT on at
    Re: Form Processing & Text Recognition For Table Extraction Issues

    Hi @AaiyanVirji,

     

    Thanks for reaching out.

     

    It can be that not all elements on the table are being recognized correctly. The fastest way to see this visually is to:

     

    1. Create a new Canvas Power App
    2. Insert the Form Processor control from the Insert --> AI Builder menu
    3. Select your model
    4. Run the app and upload a document to test. Do you see all the values in your table within rectangles like the following example? Or are there values that are not surrounded by rectangles?

      2020-06-10_19-42-48.png

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,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard