Just had a quick question about the Sharepoint search function. When I connect an app with Excel there is this search function: SortByColumns(Search(Table1, TextSearchBox1.Text, "Names",,"Names", If(SortDescending1, Descending, Ascending)) This function allows me to add as much search information as I need. So far I have Names as the only one, but I know I can keep adding more which is great.
Now when I add a data sourse through SharePoint I have to use an equation simular to this one:
SortByColumns(
Filter(SharePointList, StartsWith(Names, TextSearchBox1.Text)),
"Names",
If(SortDescending1, Descending, Ascending))
When I want to keep adding more search functions it does not work, is there a way to be able to add more search options like with the excel data equation? When I try adding more it just turns this into an error.
Solved! Go to Solution.
Hi Shawn,
I know the post is a littlbe bit older, but anyways. I had a similiar issue and it took me quite some time to figure out how to handle it. There's some kind of difference to the excel, but at the end, I found the solution:
SortByColumns(Search('sharepointlist';TextSearchBox1.Text;"columnA";"columnB";"columnC");"columnA";If(SortDescending1;Descending;Ascending))
The part with the if you don't need as I have the sorting button on my form. I hope it helps.
Best regards,
Florian
Hi @ShawnLJ,
To achieve this, you also need to use Search function in sharepoint list instead of filter. For your reference:
https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/
Regards,
Mona
Hi Shawn,
I know the post is a littlbe bit older, but anyways. I had a similiar issue and it took me quite some time to figure out how to handle it. There's some kind of difference to the excel, but at the end, I found the solution:
SortByColumns(Search('sharepointlist';TextSearchBox1.Text;"columnA";"columnB";"columnC");"columnA";If(SortDescending1;Descending;Ascending))
The part with the if you don't need as I have the sorting button on my form. I hope it helps.
Best regards,
Florian
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
175 | |
62 | |
32 | |
30 |
User | Count |
---|---|
324 | |
268 | |
104 | |
74 | |
56 |