web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Form processing - Tabl...
Power Apps
Unanswered

Form processing - Tables in two columns

(0) ShareShare
ReportReport
Posted on by 16

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?

Categories:
I have the same question (0)
  • v-siky-msft Profile Picture
    Microsoft Employee on at

    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

  • jk_one Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    16 on at

    I'm sorry, it is Stricly Confidential.

     

    Regards.

  • jk_one Profile Picture
    Microsoft Employee on at

    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

     

    table mockup.jpg
  • JoeF-MSFT Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    16 on at

    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

    table2.PNG
    TABLE1.PNG
  • micuentadecasa Profile Picture
    16 on at

    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.

  • JoeF-MSFT Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    16 on at

    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.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard