Answered

Filter gallery by distinct values if countrows is greater than 0

(0) Share

Report

Posted on by techtudoor

249

I have a PowerApp that shows metrics for work completed. I am currently using the following to show distinct work values (workCat) and then sorting on results, and this works.

Sort(
 Distinct(
 'DataSource',
 workCat.Value
 ).Result,
 Result
)

The problem is, I also see workCat records that are blank (I have a radiomenu that allows to choose by month). I would like to still show the distinct workCat, but only when CountRows(Filter(DataSource, month = viewMonth)) > 0. So if there was no workCat for the chosen month, that month would not show up in the gallery.

An example would be that if trickethelp (workCat) was zero for the month of February, then it would not show up when I select February in the radiomenu.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you post some pictures?

Was this reply helpful? Yes No
techtudoor 249 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately for this one I can not. I can try to describe it better.

DataSource:

workCat Month

trinketHelp January
benchwork January
benchwork February
benchwork February
assist January
assist February
assist March

So if I wanted to see only work completed in February, I would select February and the Gallery should show benchmark with 2 instances and assist with 1 instance.
I would like trinketHelp not to appear, since there was no trinketHelp work done in February. Currently though it does show up and has zero instances listed.

workCat I need to be distinct.

Was this reply helpful? Yes No
Verified answer

v-albai-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @techtudoor ,
Based on your information,I think you can try this formula:
Sort( Distinct(Filter('DataSource',Month = SelectedMonth),workCat.Value).Result, Result)
Just do distinct action based on filtered results.
Best regards,
Allen

Was this reply helpful? Yes No
techtudoor 249 on at

Like (0)

Report
Copy link

Link copied!

@v-albai-msft , thank you so much. I knew I had to be close with all the variations that I had tried. I had convinced myself that CountRows had to be included. This works GREAT!!!

Thank you

Was this reply helpful? Yes No