I'm trying to create a model to read thousands of pages with rows of information. Ai builder is not recognizing the table, i also created a model to recognize the fields for the first rows that works but i don't know how get to iterate on each row. To add more complication the file has 2 rows per record...
I'm very new to ai builder and power apps, any help will be appreciated.
This is the result i need for each record
|Name||AV||AMT bid at Tax sale||CO.||YR.||C/S#||Class||Code||Parcel Id||Description|
|ALLEN NETTIE HAYGOOD||520||80.82||01||00||0029||2||1||0123000220140020000000||LOT 11 BLK 4 HOMER HIGHLANDS|
Thank you for reaching out.
Today for AI Builder to detect tables, these need to be have clear separators between columns and lines. It looks like the document you are trying to use does not conform to these requirements. Unfortunately without changing the document format, there's not much that can be done today.
Having said that we are actively working on improving table extraction so stay tuned for upcoming updates.
If AI Builder is not detecting the table automatically, then there is no way today to manually define a table. If your table always has the same number of rows, you could tag each row as a separate field.
The fact that the rules around what can be detected as a table takes the AI out of AI rendering this fine for a very simple task but useless for things like real world export documentation.
Thanks for the feedback @anothersphere, I understand the frustration. This is an area where we are actively working on so expect improvements regarding table extraction in the coming months.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for the next call on June 15, 2022 at 8am PDT.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.