Skip to main content

Notifications

Power Apps - AI Builder
Unanswered

Extract information from documents with varying lines of data

(0) ShareShare
ReportReport
Posted on by 6

Hi all,

 

I'm using the AI builder to create a model which extracts data from our chemical batch receipts. The receipts are in a standardized format. The second page of the receipt contains the 'Components' list. This 'Components' list can vary from 4 products up to 11. How can I create one model to capture the component code and quantity data regardless if there are 4 line items or 11. Below are two examples of how they can vary, one with 8 line items and another with 4

 

pbiadmin123_0-1715353753288.png

 

Categories:
  • pbiadmin123 Profile Picture
    pbiadmin123 6 on at
    Re: Extract information from documents with varying lines of data

    So i've done this and it's working as expected - is there a way to reference one singular 'cell' in this table to use as an input for a 'create JSON' action?

  • Antrod Profile Picture
    Antrod on at
    Re: Extract information from documents with varying lines of data

    Hi @pbiadmin123 , 

     

    If you create a table to capture this data, it should be able to adapt to any number of lines. Make sure to give the model documents with various number of lines.

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard