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
Hi @Slloyd ,
Could you please explain in detail that what is the conditions and the corresponding results of this formula?
Regards,
Mona
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