Filter by multiple buttons

[Slloyd]

This is probably super easy but.... I am trying to filter a gallery based on 2 variables set by 2 buttons. I also want to sort by date.

Datasource: Sharepoint List called: DYW_Coverage_Cal

Variable1: NotCoveredFlag True/False

Variable2: ShowAllRecords: 0/1

SortByColumns( If(ShowAllRecords=0, Filter(DYW_Coverage_Cal,'Start Time'>=Today()),DYW_Coverage_Cal); If(NotCoveredFlag=true, Filter(DYW_Coverage_Cal,Coverage_Status.Value="Not-Covered"),Filter(DYW_Coverage_Cal,Coverage_Status.Value="Covered")), ,'Start Time', Ascending)

Thanks! Shawn

[Slloyd]

-- SORRY FOR FORMATTING ISSUES ABOVE -- This is probably super easy but....  I am trying to filter a gallery based on 2 variables set by 2 buttons. I also want to sort by date:  Datasource: Sharepoint List called: DYW_Coverage_Cal Variable1: NotCoveredFlag True/False Variable2: ShowAllRecords: 0/1 SortByColumns( If(ShowAllRecords=0, Filter(DYW_Coverage_Cal,'Start Time'>=Today()),DYW_Coverage_Cal); If(NotCoveredFlag=true, Filter(DYW_Coverage_Cal,Coverage_Status.Value="Not-Covered"),Filter(DYW_Coverage_Cal,Coverage_Status.Value="Covered")), ,'Start Time', Ascending) Thanks! Shawn

[v-monli-msft]

Hi @Slloyd ,

Could you please explain in detail that what is the conditions and the corresponding results of this formula?

Regards,

Mona

[Slloyd]

Thanks for the reply. This PowerApp is using a SharePoint Calendar as its data source.

1. By default the gallery should only show records who's "Start Time" field is >= to today. 

2. The first button should toggle off the above filter and show all records. This button uses "OnSelect" to set a variable called "ShowAllRecords" 0/1. 

3. The second button sets the variable "NotCoveredFlag" = true/false, which toggles to only show records that are "Not-Covered". It uses the column "Coverage_Status" which has a choice of "Covered" or "Not-Covered". 

The formula I posted above goes in the "Items" property for the gallery. I would like the 2 buttons / filters to work independently of each other. 

Hope that all makes sense. 

Thanks,

Shawn