Just two things. The first is the search option. So with Excel as the data source the equation lets me search mutliple criteria where when data is pulled from Sharepoint it only lets me search one thing, like their name. Second is that I am not sure how to set up a security feature with Sharepoint where no one can have access to the data in the Sharepoint list excep admins but still be able to see what is in the App.
So if you create a blank Powerapp from scratch with data using Excel then create one using Sharepoint you will see within the Browse gallary page within the search bar equation that they are different. With the excel one you can add multiple criteria to have it search where as the Sharepoing equation only allows for one search criteria to be used.
Better a late reply then never.
My conclusion is that the difference you describe is a result a lack of consistency by Microsoft in the formulas used in the making of the apps for different data sources.
You can as a fact use multiple criteria in a formula to filter SharePoint data. You just have to change the formula yourself.
I have made an app where I use this method with SharePoint data and it works as a charm.
The formula looks something like this:
Search([Datasource],[Search input reference],"Column1","Column2","Column3")
So, the search formula searches for the search text in multiple columnsin the datasource.
More info about the formula you can find here: https://docs.microsoft.com/en-us/powerapps/functions/function-filter-lookup.
Thank you for the update!
I must be missing something when I am trying to get this done.
So it would be
Search(Datasource), Row1, "Column names")
Not sure what to put for Search Input Reference
Okay that makes sense thank you!
that is what I have as my equation but it is still not working fully.