cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SumanKoduri
Helper V
Helper V

Key value pair isn't working for my PDF

Hi 

I'm trying to map part field in my PDF, when I try to use key value pair 1 st part number only it is identifying, when I try to map as table I'll not get part number alone, what can I do to achieve this ?

invoice.PNG

Thank you

2 ACCEPTED SOLUTIONS

Accepted Solutions
JoeF-MSFT
Power Apps
Power Apps

Hi @SumanKoduri,

 

Thanks for posting the question. When you trained your AI Builder form processing model, was the table detected? You can check that if there is a surrounding dotted rectangle and when you click on it the title is table_#, as in the following example:

2020-08-11_9-55-35.png

If it was not detected properly, we are working on supporting more tables in upcoming updates of the product.

As a possible workaround, if you always have the same number of rows in the table, you can tag each part number as a different field.

View solution in original post

Thanks @SumanKoduri for sharing this.

When training your form processing model, you can not specify specific elements on the table you want to extract. AI Builder will return all the table content.

What you can do is then when you consume the results in a flow in Power Automate, you can use expressions to transform the output and get what you want. For example, the following expression will take all the text in the description column for a row, and extract the part number by getting the location of the word Part and then taking the characters that follow that hold the part value.

substring(items('Apply_to_each')?['Description/value'],add(indexOf(items('Apply_to_each')?['Description/value'], 'Part:'), 5),10)  

2020-08-13_19-06-04.png

View solution in original post

5 REPLIES 5
JoeF-MSFT
Power Apps
Power Apps

Hi @SumanKoduri,

 

Thanks for posting the question. When you trained your AI Builder form processing model, was the table detected? You can check that if there is a surrounding dotted rectangle and when you click on it the title is table_#, as in the following example:

2020-08-11_9-55-35.png

If it was not detected properly, we are working on supporting more tables in upcoming updates of the product.

As a possible workaround, if you always have the same number of rows in the table, you can tag each part number as a different field.

Yes table is detecting but as u can see in attached PDF image my table description is distorted So i couldn't select as table.

Part number field is dynamic so we can't map individual items in different name

Thanks @SumanKoduri.

 

Could you share a screenshot of the step where you select fields when you create a form processing model with those documents? The step shown on the following screenshot. Please also capture the black callout with the table name and columns names. Feel free to remove/blur any sensitive information from the screenshot that you don't want to share.

2020-08-11_9-55-35.png

I'd like to see how AI Builder detects that table. Thank you!

SumanKoduri_0-1597255245416.png

This is how AI builder detects table as you can see all the fields in description taken as one column

SumanKoduri_1-1597255314038.png

This is detected words, if I map fields separately in multiple line records it's not detecting as we didn't mapped as table repeating lines it's not taking or it is not mapping multiple values that are matching with selected fields

 

Thanks @SumanKoduri for sharing this.

When training your form processing model, you can not specify specific elements on the table you want to extract. AI Builder will return all the table content.

What you can do is then when you consume the results in a flow in Power Automate, you can use expressions to transform the output and get what you want. For example, the following expression will take all the text in the description column for a row, and extract the part number by getting the location of the word Part and then taking the characters that follow that hold the part value.

substring(items('Apply_to_each')?['Description/value'],add(indexOf(items('Apply_to_each')?['Description/value'], 'Part:'), 5),10)  

2020-08-13_19-06-04.png

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,649)