Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - AI Builder / AI Builder recognizing...
Power Apps - AI Builder
Unanswered

AI Builder recognizing 2 columns as one in the line item table

(0) ShareShare
ReportReport
Posted on by ford_sopris 94

I'm working on a project to consume vendor invoices and am using a custom model (document processing) to do so.  The format in question has "Line" as the first column and "Product Code" as the second column.  The vendor has the first column right justified and the second left justified so the "Line" and "Product Code" numbers are relatively close (see screenshot attached).  Anyone have a good way of forcing AI Builder to see those as separate columns?  In the screenshot, the "Line" value is "1" and the "Product Code" is "000000018601-01".  AI Builder is recognizing the "Product Code" column with the Line column -- "1  0000005301-01"

I've trained 20 PDFs so far, do you think more will make any difference?  I'm using the "basic" table training style, would advanced make any difference?  Or am I up a creek without a paddle on this format?  I guess I could "ask" the vendor to change the justification..

Categories:
AI Builder
2022-11-02_15-23-...
  • plarrue Profile Picture
    plarrue Moderator on at
    Re: AI Builder recognizing 2 columns as one in the line item table

    Could you please send us 6 samples to aihelpen@microsoft.com so we can try to tag it?

    Thanks

  • ford_sopris Profile Picture
    ford_sopris 94 on at
    Re: AI Builder recognizing 2 columns as one in the line item table

    Is this what you are looking for?

    2022-11-02_17-07-...
  • plarrue Profile Picture
    plarrue Moderator on at
    Re: AI Builder recognizing 2 columns as one in the line item table

    Thanks @ford_wilkinson 

    Would you please send a screenshot on how you tagged the table?

  • ford_sopris Profile Picture
    ford_sopris 94 on at
    Re: AI Builder recognizing 2 columns as one in the line item table

    Can you try this one?  I had to manually edit the "Product Code" number so it would match up on the back end.  The one I trained it with was the first one I sent you but here is the one where I replaced the Product Code with what I needed.  Now it picks up both columns together

    2022-11-02_16-13-...
  • ford_sopris Profile Picture
    ford_sopris 94 on at
    Re: AI Builder recognizing 2 columns as one in the line item table

    Well..  Huh..  Let me go back to how I trained it again..

     

  • plarrue Profile Picture
    plarrue Moderator on at
    Re: AI Builder recognizing 2 columns as one in the line item table

    Hi @ford_wilkinsonwilkinson,

     

    Thanks for reaching out.

    I was able to tag a table with the sample you have provided. (I didn't used the advanced tagging mode)

    plarrue_0-1667422414641.png

     

    Please let us know how we can help better.

    Thanks

    Create a document processing custom model in AI Builder | Microsoft Learn

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Question for everyone : How are you using Create Text GPT in AI Builder?

Product updates

Microsoft Power Platform Community release plans