Skip to main content

Notifications

Power Apps - AI Builder
Answered

AI model unable to detect table correctly

(0) ShareShare
ReportReport
Posted on by 45

Hello

 

Am working on an invoice processing model and I have to added a table preview in the model to identify the different items, qty, price ...etc. on the invoice. Am currently facing 2 issues:

1. There are 2 tables on the invoice and for 4 out of the 5 invoices that I upload to train the model, the latter is detecting the wrong table.

2. In the one scenario where the correct table is detected, the model is picking 2-3 columns as one.

 

Am not sure what to do at this point. I have attached screenshots to  illustrate the issues that am facing  Any help is appreciated.

 

Thank you

 

Have a good day

 

Shadiya

Categories:
  • shadiya Profile Picture
    shadiya 45 on at
    Re: AI model unable to detect table correctly

    Thank you so much @JoeF-MSFT . It worked. I really really appreciate your help.

     

    Have a wonderful day.

     

    Shadiya

  • Verified answer
    JoeF-MSFT Profile Picture
    JoeF-MSFT on at
    Re: AI model unable to detect table correctly

    Hi @shadiya,

     

    Thanks for sharing a screenshot. I see that you have the Create CSV table inside an Apply to each loop. You need to move it outside. There shouldn't be an Apply to each loop. 🙂 

    Staples - Format entries should be put on the From field of the Create CSV table action. 

    JoeF-MSFT_0-1617833811861.png

     

  • shadiya Profile Picture
    shadiya 45 on at
    Re: AI model unable to detect table correctly

    Hi @JoeF-MSFT,

     

    Thank you for your reply. I have tried it and still the results are showing up one one line and the headers appear 2 times.

     

    shadiya_0-1617801886833.png

     

    Is there anything else that i can try?

     

    Thank you

     

    Shadiya

  • JoeF-MSFT Profile Picture
    JoeF-MSFT on at
    Re: AI model unable to detect table correctly

    Thank you @shadiya!

    You are almost there! You need to put the Create CSV table action outside of the Apply to each loop. Like this:

    JoeF-MSFT_0-1617746663014.png

     

  • shadiya Profile Picture
    shadiya 45 on at
    Re: AI model unable to detect table correctly
  • shadiya Profile Picture
    shadiya 45 on at
    Re: AI model unable to detect table correctly

    Hi @JoeF-MSFT 

     

    Please find attached screenshots of the flow, as requested.

  • JoeF-MSFT Profile Picture
    JoeF-MSFT on at
    Re: AI model unable to detect table correctly

    Hi @shadiya,

     

    Good to hear you've tried the new feature! 🙂

    Can you share a screenshot on how you've built the flow?

  • shadiya Profile Picture
    shadiya 45 on at
    Re: AI model unable to detect table correctly

    HI @JoeF-MSFT 

     

    I tried the new feature today - it worked very well in identifying the different lines on the invoice.

     

    But now i have a new issue with the way the data is being exported to CSV. I am not sure why the header is appearing 2 times and both the header and the details are showing up on one line. Any idea how to resolve this?  Am attaching my CSV file  (test2021-04-06T20_20_44.9258114Z.xlsx)  for reference.

     

    Thank you

     

    Shadiya.

  • shadiya Profile Picture
    shadiya 45 on at
    Re: AI model unable to detect table correctly

    Thank you @JoeF-MSFT - looking forward to trying it next week. I will definitely give my feedback.

     

    Have a good evening.

     

    Shadiya

  • JoeF-MSFT Profile Picture
    JoeF-MSFT on at
    Re: AI model unable to detect table correctly

    Hi @shadiya,

     

    Thank you for posting this question, it comes in a good moment because this Friday we are releasing an update to Form Processing that will let you tag that table correctly. Explicitly tag tables in form processing - Power Platform Release Plan | Microsoft Docs

     

    Just a few more days 🙂 Looking forward you trying it out. Would love to hear your feedback once you try it.

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard