Unanswered

Gallery filtering by a lookup column

(0) Share

Report

Posted on by derekma19

Hi,

I have a gallery as the below

ID	Address	Status
A	xxxxxx	Active
B	yyyyyy	Inactive
C	zzzzzz	Active

This gallery is composed from two dataverse table

Table_1: With ID and address

Table_2: With ID and status

The items property of the gallery is Table_1, and column Status is a Lookup column with the formula Lookup(Table_2,ID=ThisItem.ID).Status.

I want now to create a dropdown with items ["Active","Inactive"] in order to filter the gallery by those values, but not sure how to do it. I also would need to use non-delegable functions as I will have several thousand of records.

Any suggestion will be much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

TikshaAggarwal on at

Like (0)

Report
Copy link

Link copied!
Hi @derekma19,
Here I have used collection to store static data. You may replace it with your DataSource. Then merge tables and filter the gallery data based on dropdown selected item.

Filter(Combine_Tbl, Status=Dropdown1.Selected.Value)

Please click Accept as solution if this helped you solve your issue. This will help others find it more readily. It also closes the item. Please consider giving it Thumbs Up.

Was this reply helpful? Yes No
derekma19 on at

Like (0)

Report
Copy link

Link copied!

Just to give an update on this. At the end I solved this merging queries using dataflows as I had to use this in any case to load data from CSV, so merging this and adding a query, I solved the issue.

Was this reply helpful? Yes No