Filter Gallery by Dropdown and Text Input

[rowanb]

Im new to Powerapps and have read numerous threads on the same topic but haven't managed to translate it into my app yet. I have a sharepoint list titled PalmersNDDPoints and am trying to filter the records through a dropdown from a collumn titled NDDAREA. Id also like users to be able to search for a specific record (from a SP collumn titled NDDNumber within the same SP list) within the result of the dropdown selection. 

Ive managed to make this work individually, but havent been able to combine the two filters. 

The Gallery.Items to filter by dropdown is below.

Filter(PalmersNDDPoints, NDDArea = DropdownSiteAreaSelector.Selected.SiteArea)

with the dropdownsiteselector.items filtering the site area from a different SP list

Filter(NDDSitesAreas, SiteName = DropdownSiteSelector.Selected.Result)

The Gallery.Items to filter by text input is below.

If(TextHoleFilter.Text = "Hole ID", PalmersNDDPoints, Filter(PalmersNDDPoints, StartsWith(NDDNumber,TextHoleFilter.Text)))

All the SP lists are less than 2000 records, so i dont believe im running into delegation issues?

I have tried the following, but with no luck!

Filter(PalmersNDDPoints,NDDArea = Dropdown1.Selected.SiteArea + NDDNumber = TextInput1.Text)

and

Search(Filter(PalmersNDDPoints, NDDArea = DropdownSiteAreaSelector.Selected.SiteArea), TextHoleFilter.Text,"NDDNumber")

If anyone could help, that would be appreciated.

[WarrenBelz]

Hi @rowanb 

Try

Filter(
   PalmersNDDPoints,
   NDDArea = Dropdown1.Selected.SiteArea &&
   NDDNumber = TextInput1.Text
)

I am assuming of course that these are valid control outputs and they match the type and content of the target field.

Please click Accept as solution 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 Thumbs Up.

[v-xida-msft · Accepted solution]

Hi @rowanb ,

Based on the formula that you mentioned, I think there is something wrong with it. Please consider modify your formula as below (set the Items property of Gallery to following😞

Filter(
       PalmersNDDPoints, 
       NDDArea = DropdownSiteAreaSelector.Selected.SiteArea,
       If(
          TextHoleFilter.Text = "Hole ID",
          true,
          StartsWith(NDDNumber, TextHoleFilter.Text)
       )
)

Please take a try with above solution, then check if the issue is solved.

Best regards,

[rowanb]

Thanks @WarrenBelz 

That did the trick (nearly), however only filtered when a value was in the text input.

[rowanb · Accepted solution]

hi @v-xida-msft 

That formula appeared to work well. 

thankyou

rowan

[v-xida-msft]

Hi @rowanb ,

If the solution I provided above could help solve your problem, please consider go ahead to click "Accept as Solution" to identify my reply as Solution.

Best regards,

[WarrenBelz]

Thanks @rowanb ,

And I would have fixed that when you responded.

[rowanb]

Thanks @WarrenBelz . I appreciate your help 🙂