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
Solved! Go to Solution.
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)
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.