Unanswered

SharePoint List sort, Filter and search

(0) Share

Report

Posted on by Devang

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-micsh-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
Dev 35 on at

Like (0)

Report

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.

Was this reply helpful? Yes No