Unanswered

Combining a seach box with existing drop downs and search "All"

(0) Share

Report

Posted on by JC-18030151-0

I’ve got two filters on my Moggill Natives app; one for the sharepoint list column ”In the Nursery” and the other for “Growth form”. Both work well except they don’t cater for the “All” possibility. The “In the Nursery” function on the dropbox is:

Distinct(SharePointList,'In the Nursery'),

And on the “Growth form” is:

Sort(Distinct(SharePointList,'Growth form'),Value)

The Gallery function is :

Filter(SharePointList,'In the Nursery'=Dropdown1.Selected.Value && 'Growth form'=Dropdown2.Selected.Value)

My question is ‘What do I need to change in the gallery to add a search box to search for two columns in the SharePoint list (“Species” and “Common Name”) please?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

SpongYe 5,905 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Johno1

To add a search box to filter your gallery by two columns in the SharePoint list, you can use the Search function in Power Apps. The Search function returns a table that contains records that match one or more search strings in one or more columns. You can specify which columns to search and how to rank the results.

To use the Search function, you need to add a Text input control to your screen and name it SearchBox. Then, you need to modify the Items property of your gallery to include the Search function.

For example, you can use this formula:
Items =
Search( Filter( SharePointList, 'In the Nursery' = Dropdown1.Selected.Value && 'Growth form' = Dropdown2.Selected.Value ), SearchBox.Text, "Species", "Common Name" )

This formula will filter your gallery by the values selected in the two dropdowns, and then search for the text entered in the SearchBox in the Species and Common Name columns of the SharePoint list. You can adjust the formula to suit your needs and preferences.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
JC-18030151-0 22 on at

Like (0)

Report
Copy link

Link copied!

SpongYe, Thank you for your quick reply. Unfortunately, neither filter box is working now, and the search function is now working but delivering a delegation warning. I wonder if an "If blank" expression needs to be added? But thank you anyway.

Was this reply helpful? Yes No
JC-18030151-0 22 on at

Like (0)

Report
Copy link

Link copied!

Sorry, the search function is NOT working. My typo and wishful thinking. Cheers.

Was this reply helpful? Yes No
SpongYe 5,905 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Johno1

Lets rewrite the code to avoid delegation:
With( { _SharePointList: Filter( SharePointList, 'In the Nursery' = Dropdown1.Selected.Value && ) }, Search( _SharePointList SearchBox.Text, "Species", "Common Name" ) )

Please let me know what kind of errors occurs.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
SpongYe 5,905 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Any updates?

Was this reply helpful? Yes No
JC-18030151-0 22 on at

Like (0)

Report
Copy link

Link copied!

SpongYe,
Sorry, I was planting native plants yesterday. To your suggested code change with the 'with' statement:
With(
{MCN_Plants5:
Filter(
MCN_Plants5,
'In the Nursery' = Dropdown1.Selected.Value && 'Growth form'=Dropdown2.Selected.Value
)
},
Search(MCN_Plants5
SearchBox.Text,
Species,
'Common Name'
)
)

I got two lots of errors pertaining to the problem;
1) Expected operator. We expect an operator such as +.*....
2) Formatting errors eg If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)

The filter part works OK, but the search doesn't. I was thinking it might be a problem with the field names? Could I share the app with you to have a look at? But regardless, thanks for the help to date. 🙂

Was this reply helpful? Yes No
SpongYe 5,905 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Johno1

Everything look good. Only thing is some syntax are correct in the Search function.
Columns to search must contain text. Column names must be strings and enclosed in double quotes.
So I adjusted your code and try again:
With( { MCN_Plants5: Filter( _MCN_Plants5, 'In the Nursery' = Dropdown1.Selected.Value && 'Growth form' = Dropdown2.Selected.Value ) }, Search( _MCN_Plants5 SearchBox.Text, "Species", "Common Name" ) )
Otherwise send me a private message to take a more indepth look into this.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No