Is it possible to set an initial filter for a SharePoint list data source that will be valid for the whole applications? Like, I connect to a "cars" list, but I would like to work only with the "blue" cars.
I know, I can set a filter every time I work with the data source, but I hope there's a simple way to do this in advance.
Initial query of data source
Viewed 107
1 Answers
Currently there isn't a way to apply a global filter for a data source (you can consider creating a new feature request in the PowerApps Ideas board).
One alternative for this would be to load the filtered data in a collection, and work from that collection instead of the list directly:
ClearCollect(
BlueCars,
Filter(cars, color = "blue"))
If your application mostly queries the list (and the size of the list is small enough for delegation not to be a problem), then it should work. You would need to re-query the list anytime your app makes a change.
Related