Unanswered

2 collections in one gallery possible?

(0) Share

Report

Posted on by tsangd

Hi, I want to use two collections for a gallery because the data is seperate.

Is there an easy way to do this?

My two collections are: 1. BuyRecords
2.UsedRecords

Im new to powerapps so please tell me the syntax

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

amolPomaji 28 on at

Like (0)

Report

Hey @tsangd, Yes, It is possible.
Using the filter function you can do this.
assumes the ID columns are matching criteria and will return the name as a result. Note While First is not delegable, Filter is so it will work on any number of records.
You can use this one :-
First(Filter(Othercollection,ID=ThisItem.Empid).Name

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
tsangd 39 on at

Like (0)

Report

@amolPomaji
Thanks for the reply but what is ID? im getting an error at that

First(Filter(UseRecord,ID=ThisItem.BuyPerson).UseDate)

Not sure about your answer

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report

@tsangd actually it's "not" possible two show 2 collections in one Gallery. A Gallery is meant for displaying data from a single collection. So each record of a collection will be one Item in the collection.

But you could join both collections into a single collection for example. Or you could lookup information from a second collection.

Maybe you could describe in more detail what you are trying to achieve. How do the 2 collections relate to each other?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No