only the first invoice item can be read when using Form Processing module

[JoeAu]

i use apply each to loop the invoice item table defined in Form Processing module as below

The item define as below

I test run. It always read the first invoice item, the rest items cannot be read.

what wrong is it?

or i define the invoice detail table is wrong?

thanks.

[JoeF-MSFT]

Hi @JoeAu,

Thanks for posting this question.

If you navigate to the AI Builder --> Models section, go the the details page of the model you trained and then do a Quick test with the invoice you are using in your flow. Do you see the whole table being detected correctly?

[JoeAu]

i do the quick test with result as below

what can i do?

delete the model and create a new one?

thanks

[JoeAu]

I edit the model and find that it only recognize the first item as below

how can i tell the AI to collect all the items?

In "ITEM CODE / DESCRIPTION" column, the first line is ITEM CODE, the second & third line is DESCRIPTION.

how can I mark it?

thanks

[JoeF-MSFT · Accepted solution]

Thanks @JoeAu for checking. Unfortunately, AI Builder is not able to correctly detect the table, probably because in some lines the description takes multiple columns.

Currently there is no way to tell the model how to extract a table that is wrongly detected. This will be posible however in the upcoming AI Builder 2021 Release Wave 1 update. Stay tuned for this!

[JoeAu]

When will be Wave 1 update ?

Where can I check it ?

Thanks

[JoeF-MSFT]

Hi @JoeAu,

Wave 1 will be available starting April 2021. 

We communicate the release of new updates through the blog: Power Automate - Blog (microsoft.com)

[JoeAu]

thanks @JoeF-MSFT 

one more question, if I start a new AI module and submit another 5 invoices, the AI can recognize the items correctly? 

[JoeF-MSFT]

Hi @JoeAu, for this type of table adding more invoices won't help to better recognize the table unfortunately.