Filtering in Dataverse View like SQL Views?
Hi all, I have a simple usecase (I assumed). Just like within SQL I would like to create some views based on my Dataverse table, so that we can use those views directly in Power Apps instead of filtering in the app.
Just like in SQL, I would create multiple views based on my SQL table, so that end-users only get to see the data they need to see without filtering themselves.
For example: I want to filter my table on all the records where column Day = Monday, but the column Day does not show up in the filtering.
It seems like I can't choose custom columns for filtering....
I would've imagined this is like a basic functionality. Does someone know how we can filter on Custom columns?
Thanks in advance!
EDIT:
I added some extra context:
I would like to filter on all the rows where Valid = No or where Day = Monday, but I can't choose either of the 3 columns from my Table:
EDIT 2: found the solution!
Seems like I had to set my columns to Searchable (= Yes)