cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
micuentadecasa
Level: Powered On

Form processing - Tables in two columns

Dear all,

 

I'm working with a PDF that has two tables with the same columns in the same page (so it is the same table, in a two columns format) and when the model recognizes them, it renames the columns of the second table to the name + "2", I mean, the first column is recognized as price and the second as price2, I would like to have only one resulting table. How I can do it?

9 REPLIES 9
v-siky-msft
Level 10

Re: Form processing - Tables in two columns

Hi @micuentadecasa,

 

I am afraid there is no way to merge two tables with the same columns

The Form processing only can treat your PDF as two form because there are two table in it.

If you want this feature, please submit an idea: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas 

Best regards,

Sik

Power Apps Staff jk_one
Power Apps Staff

Re: Form processing - Tables in two columns

Hi @micuentadecasa,

 

If it’s not confidential, would you be ready to share the data set you are using / want to improve so I can check with the product team ? 

 

You can send me a sample in a PM.

 

Thanks in advance,

 

JK

micuentadecasa
Level: Powered On

Re: Form processing - Tables in two columns

I'm sorry, it is Stricly Confidential.

 

Regards.

Power Apps Staff jk_one
Power Apps Staff

Re: Form processing - Tables in two columns

Hi @micuentadecasa 

 

I have attached a *very simplified* mockup of what I would image the 2 tables would look like.

 

Can you please confirm if this fits what you're describing ?

 

Thanks in advance,

 

JK

 

Power Apps Staff JoeF-MSFT
Power Apps Staff

Re: Form processing - Tables in two columns

Hi @micuentadecasa,

 

A possible solution to this is when you use the model in Power Apps or Power Automate, merge the two tables together after you process the document with the built-in formulas. 

micuentadecasa
Level: Powered On

Re: Form processing - Tables in two columns

thanks @jk_one , almost, imagine that is one page, of all the pages that you have for training, the rest of the pages are similar, all they have two columns and one table in each column, but  you have another page with the same structure but in one of the columns you have more than one table, please see attachment; this is very common in some invoices, imagine you control the data for multiple clients in a single invoice from a provider, you have the data in multiple tables for different users, see attachment Table2.

 

Regards

micuentadecasa
Level: Powered On

Re: Form processing - Tables in two columns

Hi @JoeF-MSFT , I thought about it, I would like to see some sample; anyway, I think it is easier that AI builder allow multiple tables and columns in the model, there are many invoices with this format and I don't think it is so difficult for your team of researchers, at the end, what makes this AI Builder interesting is, that the AI does the job. Please see my answer to your colleague in this same post, where I put some samples that you can try.

 

Regards.

Power Apps Staff JoeF-MSFT
Power Apps Staff

Re: Form processing - Tables in two columns

Thanks @micuentadecasa. Would it be possible for you to put a mock, sample document of an invoice with that structure and share it with us?

micuentadecasa
Level: Powered On

Re: Form processing - Tables in two columns

I'm deeply sorry, but the forms I have are strictly confidential, but I can suggest that you use phone billings, for example, in my family's phone billings I can find next:

 

- logos and key value pairs (in each page there is a key value pair denoting the mobile phone that the page is referring to, for example, my son's phone)

- complex tables, in each page you can find different tables for national, international or other type of calls, but at the end the structure of this tables and their fields are the same, but maybe not the table's location.

 

it is important the first point, at the end all tables are the same kind, but in the details of the page there is a code that differentiates it; if you are able to get the tables, but you can not differentiate them, then you got only a partial solution (one trick can be to process every page independently)

 

Regards.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,230)