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 / 1 collection from 5 ta...
Power Apps
Unanswered

1 collection from 5 tables (same column names)

(0) ShareShare
ReportReport
Posted on by 3

Hello, 

I have 5 tables, each with 15+ columns, however all of them have columns for "Name", "User", and "RequestType".

 

I would like to create a collection (called collectInquiry) with only the Name, User, and RequestType columns in order to summarize these 5 tables in a PowerApps gallery.

 

Can anyone help me with the Fx?  

 

Thank you very much in advance!

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @JohnnyAileron 

    A collection is not needed.  You can set the Items property of your Gallery to:

    Ungroup(
     Table({Items: ShowColumns(List1, "Name", "User", "RequestType")},
     {Items: ShowColumns(List2, "Name", "User", "RequestType")},
     {Items: ShowColumns(List3, "Name", "User", "RequestType")},
     {Items: ShowColumns(List4, "Name", "User", "RequestType")},
     {Items: ShowColumns(List5, "Name", "User", "RequestType")}
     ),
     "Items"
    )

     

    If you must duplicate your data in your app memory for some other reason, then the above can be used in a collection statement as well.

     

    I hope this is helpful for you.

  • JohnnyAileron Profile Picture
    3 on at

    Thank you for the lightning fast response!   I think this is close, but I should clarify my situation...

    I have 5 tables of data, and the code above only references a single table (I think)

     

    Since I can only select 1 datasource/table for my gallery, I don't understand how to show names/users/RequestTypes from all 5 tables in one gallery.

    Thank you for your patience as I know I'm missing something obvious.

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @JohnnyAileron 

    The formula I provided specifically has List1 through List5 - so, 5 different tables.

    Just replace the reference to List1 through List5 to be your list names.

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 70

#2
WarrenBelz Profile Picture

WarrenBelz 64 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 36 Super User 2026 Season 1

Last 30 days Overall leaderboard