Question about search. How can I search for d...

[Michael_Serafin]

Question about search. How can I search for data in Yes/No Columns?

I’ve made the column searchable. The goal is to find all rows that have False in the PAID column.

Thanks in advance

Michael

[Steven_Coile]

The Searchable option determines whether the column content is searchable from the search bar in the user interface. The phrasing of your question suggests you’re interested in searching from an expression instead. To search from an expression…

This will return a List containing the values of the [DesiredColumn] in MyTable for rows where [PAID] is TRUE:

select(MyTable[DesiredColumn], ([PAID] = true))

Since [PAID] is a Yes/No column, you can simplify the above slightly:

select(MyTable[DesiredColumn], [PAID])

[Michael_Serafin]

Thanks.

I found using a slice then adding to a UX as a button at the bottom works great.

[Steven_Coile]

The Searchable option determines whether the column content is searchable from the search bar in the user interface. The phrasing of your question suggests you’re interested in searching from an expression instead. To search from an expression…

This will return a List containing the values of the [DesiredColumn] in MyTable for rows where [PAID] is TRUE:

select(MyTable[DesiredColumn], ([PAID] = true))

Since [PAID] is a Yes/No column, you can simplify the above slightly:

select(MyTable[DesiredColumn], [PAID])

[Michael_Serafin]

Thanks.

I found using a slice then adding to a UX as a button at the bottom works great.