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

All responses (3)

Answers (0)

Sort by

M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
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
bp3378 114 on at

Like
a
(1)

Report
Copy link

Link copied!

thanks for your reply. I was able to solve it using a filter within a filter.
M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!

@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