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