Filter the gallery which has lookup column

(0) Share

Report

Posted on by Idris_Mohd

Hello All,

I have a Canvas App in which I'm displaying a gallery and the table used for that galley is "tbl_engine" and I'm displaying a column inside that galley using lookup function and the code for that column is

lookup(tbl_commodity, commodity_id= int(lookup(tbl_eng_commodity, eng_id=thisite.eng_id, commdity_code)),part_number);

I would like to filter the galley with the help of part_number displayed in the gallery.

the items property of the gallery has the below code

Filter(tbl_engine,

eng_id=dropdown1.selected.value,

search_1.text in text(eng_description))

I've tried different ways to add that condition in the above filter but no luck. Looking forward to hear from the community.

Thanks

Idris

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

SaiRT14 1,990 Super User 2025 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi CU26120737-0,

lookup function Lookup(tbl_commodity, commodity_id =
Value(Lookup(tbl_eng_commodity, eng_id = ThisItem.eng_id, commdity_code)), part_number)

To filter the gallery by part_number, add the lookup logic into the Filter function of the gallery's Items property.

Items Property Code: Filter(
tbl_engine,
eng_id = Dropdown1.Selected.Value,
Search_1.Text in Text(eng_description),
Lookup(
tbl_commodity,
commodity_id = Value(Lookup(tbl_eng_commodity, eng_id = eng_id, commdity_code)),
part_number
) = Search_2.Text
)

tryout and let me know if you have issues.

Was this reply helpful? Yes No
Suggested answer

CU26122340-0 2 on at

Like (0)

Report
Copy link

Link copied!

If you are using Dataverse/SQL server or similar (as opposed to sharepoint lists); Create a view joining tbl_engine with tbl_commodity...something like 'SELECT * FROM tbl_engine INNER JOIN tbl_commodity ON tbl_engine.eng_id=tbl_commodity.eng_id;'. Then in items property use: Filter(view, part_number = dropdown1.Selected.Value).
The lookup used for partnumber would become ThisItem.part_number instead of a lookup (the lookup now being down by dataverse/SQL Server.)

Was this reply helpful? Yes No
Idris_Mohd 2 on at

Like (0)

Report
Copy link

Link copied!

The Data source for this application is Dataverse. We have more than 30 tables to fetch the data and use them in this application and We don't want to merge the tables as the number of columns and the data is getting increased which will have an impact on the performance. Hence we want to use the lookup functionality to reduce the size of the tables.

Was this reply helpful? Yes No
WarrenBelz 153,779 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Idris_Mohd

Firstly try this
LookUp( tbl_commodity, commodity_id = int( LookUp( tbl_eng_commodity, eng_id = ThisItem.eng_id ).commdity_code ) ).part_number

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No