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
Solved! Go to Solution.
Please take a try to with the following way for the SharePoint data:
Filter(SharePointList, StartsWith(Names, TextSearchBox1.Text)),
If(SortDescending1, Descending, Ascending))
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?
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.
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.
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.
Your data source should be in single quotes because it has a space in it.
So something like this:
Plus you can delete the dubble quotes in the default property.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.