1 collection from 5 tables (same column names)

(0) Share

Report

Posted on by JohnnyAileron

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
JohnnyAileron 3 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No