cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShawnLJ
Level: Powered On

substitute for the search function

I have been doing some research on Delegation (Little blue dot that shows up at the top left of search data) and was able to find out why my formula was not working for data from a SharePoint list but the same formual was working for excel data. It turns out the Search function is not currently compatible to a SharePoint list as this link tells me: https://powerapps.microsoft.com/en-us/tutorials/delegation-list/. That being said I am assuming I may be able to do the same thing with the search as with Filter and/or the lookup formulas. I just cant seem to figure out how to make it happen. Here is the formula that worked great for excel document but did not work for the Sharepoint data. 

SortByColumns(Search(Table1, TextSearchBox1.Text, "Names",,"Names", If(SortDescending1, Descending, Ascending)) 

 

If anyone knows how I cam mimic this with Sharepoint data that would be great

thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
ShawnLJ
Level: Powered On

Re: substitute for the search function

Okay I just created a new app and it worked. So whatever the problem was just recreating the app got rid of the issue I was having on the other one. Thank you!

15 REPLIES 15
Community Support Team
Community Support Team

Re: substitute for the search function

Hi @ShawnLJ,

 

Please take a try to with the following way for the SharePoint data:

SortByColumns(
Filter(SharePointList, StartsWith(Names, TextSearchBox1.Text)),
"Names",
If(SortDescending1, Descending, Ascending))

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ShawnLJ
Level: Powered On

Re: substitute for the search function

Thank you for that. It is now giving me an error, here is a pic of what is looks like, the name of the table is correct, the name of the search box is correct, the Names column is correct  as well. Is there anything else I can try?

 

 

Super User
Super User

Re: substitute for the search function

Hey @ShawnLJ

 

 

What is the error exactly?

 

Kind regards

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





ShawnLJ
Level: Powered On

Re: substitute for the search function

When I hover over the error it says "Expected an operator (eg., +, *, &&).

When I hover over the equation itself it says: Invalid Number of arguments. The function filter has some invlid arguements. 

Super User
Super User

Re: substitute for the search function

Hey @ShawnLJ

 

 

This code needs to go into the items property of your gallery.

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





ShawnLJ
Level: Powered On

Re: substitute for the search function

Thanks Tom I had it in the Defalt Property. Do I need top put anything into the Defalt property. Here is what it looks like now that I have put it into the items property. Error is saying I have invalid names and the filter function has some invalid arguments. 

 

Capture.JPG

ShawnLJ
Level: Powered On

Re: substitute for the search function

Just to clarify on this. When I put in the equation into the items section it automatically moves the data source to no data so when I click the data source it then deletes the equation.

Super User
Super User

Re: substitute for the search function

Hey @ShawnLJ

 

 

Your data source should be in single quotes because it has a space in it. 

So something like this:

'succesion program'

Plus you can delete the dubble quotes in the default property.

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





ShawnLJ
Level: Powered On

Re: substitute for the search function

Thanks Tom that has fixed all the errors but for some reason when I type in a name it is not searching anything. 

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 398 members 5,696 guests
Please welcome our newest community members: