Announcements
Hi,
I have connected the app to a data source that contains many rows. I am using the Search box to search, I was wondering how to filter and not show the garbage information ( as the data source is a sandbox environment). for example how to filter Customer name starting with # or ( and prevent it from appearing when the data source is loading
Many thanks
So you could wrap a filter function around the search where you filter out the text you don't want to see with IsMatch and a regular expression like so Filter(Accounts, IsMatch(Name,"[a-z]+"))
Thanks for your reply, sorry I am new to power apps
Could you please add the filter in the formula where it makes sense?
Sort(Search(Accounts, TextInputSearch.Text,"Name"), Name, Ascending)
Hi @Aysan ,
Im not sure if it will work but try this:
Sort( Search(Filter(Accounts, IsMatch(Name,"[a-z]+")),TextInputSearch.Text,"Name"), Name, Ascending)
Sorry @Aysan, just replace accounts source in your search.
Sort(Search(Filter(Accounts, IsMatch(Name,"[a-z]+")), TextInputSearch.Text,"Name"), Name, Ascending)
Thank you both for your replies 🙂
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 432 Super User 2026 Season 2
Mohsin Ali 347
WarrenBelz 254 Most Valuable Professional
