Unanswered

In a Gallery, how do I filter a datasource based on search of child field?

(0) Share

Report

Posted on by bp3378

114

I have a gallery that shows records from dataverse based on search fields. Most of the search fields is based on the main table, but one of the search fields is a dropdown control that lets user search for the location based on the child table field.

So it goes something like this:

Main table <-- [ childtable locationField(lookup) ] ---> Location Table

So the dropdown in the search, searches for the location. So in the Gallery I want to show records from the main table that has any of its child records with that location.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

M_Ali_SZ365 1,110 on at

Like (0)

Report
Hi @bpw ,
Try the Code Like This
assuming your main table is called MainTable, your child table is called ChildTable, and the relationship is based on the LocationField:
Filter( MainTable, LookUp( ChildTable, ParentRecordID = MainTableID && LocationField = Dropdown.Selected.Value ).LocationField = Dropdown.Selected.Value )
replace MainTable, ChildTable, ParentRecordID, MainTableID, LocationField, and dropdown with your actual table and column names.
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

Was this reply helpful? Yes No
bp3378 114 on at

Like (1)

Report

thanks for your reply. I was able to solve it using a filter within a filter.

Was this reply helpful? Yes No
M_Ali_SZ365 1,110 on at

Like (0)

Report

@bpw ,
If My Solution is helpful for you then accept please help for others
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

Was this reply helpful? Yes No