Notifications
Announcements
Hello,
I am building an application named School in powerapps with connecting to sharepoint list. I want my app to search for speacfic things like School Name and Area. I am not sure what to do. I tried to change the sort but my filter got screwed up and if i change my TextSearchBox1 niothing works but gets an error. I also would like to add dropdown controls and link to search, so users can search and select from dropdown to make navigation more particular.
I would Thank Powerapps Staff in advance.
Hi @Devang,
Would you please share the error message?
If you would like to filter the SharePoint list with a single searchBox for multiple fields, then please consider take use of the search function:
Filter, Search, and LookUp functions in PowerApps
Formula should be:
Sortbycolumns(Search(SharePointList, TextSearchBox1.text, SchoolNameField, AreaField), "Title", If(SortDescending1, Descending, Ascending))
Regards,
Michael
I already went through the link. But that doesnot work. If i use your query function to chamge my seachTextBox field then what i have to use in my sort and filter. Can you please help me urgently.
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 793 Most Valuable Professional
Michael E. Gernaey 333 Super User 2025 Season 2
Power Platform 1919 268