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
Check out new user group experience and if you are a leader please create your group
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
255 | |
254 | |
81 | |
41 | |
30 |
User | Count |
---|---|
317 | |
263 | |
122 | |
64 | |
49 |