Sort grouped by distinct users gallery by countif value

(0) Share

Report

Posted on by mohanade

Hi All

I need your support in the below case

I have a gallery containing distinct users based on selection form another gallery (Gallery5)

i need to sort this gallery based on the number of repeating this user on the gallery

this formula is working fine with the gallery but i can't add the needed column to sort the gallery by it

Filter(
ForAll(
Distinct(
Kudos ,
'Kudos to'.Email
),
LookUp(
Kudos,
'Kudos to'.Email= Result And Title=Gallery5.Selected.Title
)
),Title=Gallery5.Selected.Title)

this is the count formula and it's working

CountIf(Kudos,Title=Gallery5.Selected.Title And 'Kudos to'.Email=ThisItem.'Kudos to'.Email)

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

mohanade 65 on at

Like
a
(0)

Report
Copy link

Link copied!

any support guys?
Verified answer

Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@mohanade

With({tempFiltered: Filter(Kudos, Title = Gallery5.Selected.Title)}, Sort( AddColumns( Distinct(tempFiltered, 'Kudos to'.Email), "countAppear", CountRows(Filter(tempFiltered, 'Kudos to'.Email = Result)) ), countAppear, Descending ) )
mohanade 65 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you so much, it works