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 / Need to combine 3 tabl...
Power Apps
Answered

Need to combine 3 tables to one

(0) ShareShare
ReportReport
Posted on by 292

Hello All, 

I have excel which has rows of about 50k records. I tried to add this in One drive and access but there are limitation with respect to file size and rows of only 2000 records.

I have come up with an idea of segregating one workbook into 3 different workbook with 15000 records which holds good for static excel.

Challenge what i am facing is i want to show the data in the gallery and also dropdown based on the table.

How to combine all 3 tables to one single table so that i can fetch the data from there?combining table.png

Categories:
I have the same question (0)
  • Florian_Kleinz Profile Picture
    227 on at

    Hello,

     

    you can use Table(Table_1,Table_2,Table_3) but writing back might be difficult with this approach.

     

    Best regards

  • nagaraj007 Profile Picture
    292 on at

    Hi Florian,

    Where do you want me to write this Table(Table_1,Table_2,Table_3)?

    at the start of the app i wrote i am getting error. Please advise

  • eka24 Profile Picture
    20,923 on at

    If it is a static Data as you have it in the excel Table.

     

    First import the excel Tables onto Powerapps, example Table1, Table2, Table3

     

    After connecting, the 3 Tables, create a collection OnStart or Onvisible or Onselect of a Button;

     

    ClearCollect (MyCombinedTable, Table1, Table2, Table3)

     

    You can then use MyCombinedTable which will contain the full data

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • nagaraj007 Profile Picture
    292 on at

    Hi,

    i added the formula but the data is not reflecting. Please advise

    nagaraj007_0-1596191995331.png

     

  • nagaraj007 Profile Picture
    292 on at

    Hi,

    I want to show the data to the users, they will not be writing back in this app. 

     

    Gallery shows blank, dropdown shows blank

     

    nagaraj007_0-1596192337748.png

     

  • Verified answer
    eka24 Profile Picture
    20,923 on at

    Where did you put the formula. If onvisible, go to another screen and back. If OnStart, restart the App

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard