Key value pair isn't working for my PDF

[SumanKoduri]

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 ?

Thank you

[JoeF-MSFT · Accepted solution]

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:



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.

[SumanKoduri]

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

[JoeF-MSFT]

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.



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

[SumanKoduri]

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

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

[JoeF-MSFT · Accepted solution]

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)