Forum Discussion

chudson002's avatar
chudson002
Brass Contributor
Dec 07, 2021
Solved

GALLERY COUNT

  Good Day.  Was wondering if anyone could assist.  Have 2 galleries, when status is selected (top), it should filter the gallery below. (1) The count and items are correct, but when selectin...
PowerApps
  • chudson002's avatar
    chudson002
    Dec 15, 2021
    Was assisted with finding a resolve. The below worked great!

    If(ThisItem.Filter = "All", CountRows(Filter(TrainingTravel_1, 'Created By'.Email= varUser.Email)), CountRows(Filter(TrainingTravel_1, Status = ThisItem.Filter && 'Created By'.Email= varUser.Email)))

    V/R
    chudson002
chudson002's avatar
chudson002
Brass Contributor
Dec 08, 2021

CountRows(Filter(TrainingTravel_1, Status = ThisItem.Filter Or ThisItem.IsSelected && 'Created By'.Email = varUser.Email))

Got the aggregated number to appear, but.........

when each button is clicked, the total will appear in current, when the next is clicked, the previous returns to correct number and the next displays total.

 

 

 

chudson002's avatar
chudson002
Brass Contributor
Dec 08, 2021

Gallery (1) now displays the correct count when button is selected...still working on "All" to display "5".

 

 

  • chudson002's avatar
    chudson002
    Brass Contributor
    Dec 15, 2021
    Was assisted with finding a resolve. The below worked great!

    If(ThisItem.Filter = "All", CountRows(Filter(TrainingTravel_1, 'Created By'.Email= varUser.Email)), CountRows(Filter(TrainingTravel_1, Status = ThisItem.Filter && 'Created By'.Email= varUser.Email)))

    V/R
    chudson002

Resources