I have a Gallery (named as galInspection) where the Items property is set as below. (New or Edited items shows on top within the Gallery using below expression)
SortByColumns(Search('SharePoint List Name', TextInput1.Text, Employee Name, 'Customer Name', Status),"Modified", SortOrder.Descending)
TextInput1 is used to Search the Gallery for Employee Name, Customer Name and Status
My requirement is to add 4 Buttons to filter the Gallery on click on this buttons.
For Instance: My Status column is a Text Input, which is a calculated field and updates as "In Progress" or "Completed"
Add a Button for Status and on click of this button, filter the Gallery which only says "In Progress". In this Button text also show Count of "In Progress". I'm using below expression In Text property
CountIf('SharePoint List Name', Status="In Progress")
Similarly I need one button for Response Date. On click on this button filter the gallery where Response Date is blank and show the Count in text property of this button.
Need assistance on filtering the gallery on click on buttons. Please advise. Thanks!