Hi everyone.
I am currently filtering a gallery with this formula:
SortByColumns(Filter(NSOEAMLIST,Dropdown1.Selected.Value="All" || Category = Dropdown1.Selected.Value),"Task")
It is working correctly but I want to add a checkbox outside the gallery that will filter out items where the Sharepoint column "WhoChecked" is blank. Im not sure where to place the additional formula or the correct syntax.
Thanks!!
Chris
Perfect, thank you very much for the help!!
Chris
@ckserra33 Try Below
Checkbox: OnCheck: Set(varShowWhoChecked,true)
Checkbox: OnUnCheck: Set(varShowWhoChecked,Blank())
SortByColumns(Filter(NSOEAMLIST,Dropdown1.Selected.Value="All" Or Category = Dropdown1.Selected.Value, IsBlank(WhoChecked) Or !IsBlank(varShowWhoChecked) = false),"Task")