web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter + Distinct Form...
Power Apps
Unanswered

Filter + Distinct Formula in BrowseGallery issue

(1) ShareShare
ReportReport
Posted on by 920 Super User 2024 Season 1

Hi,

 

I have this formula trying to get the weeks for each Staff Name.

 

Filter('Scheduling List', 'Staff Name' = PersonID, Week)

 

The data would be like this - 

 

Staff NameWeekProject
Louis Stevens2023_01_02

abc

Louis Stevens2023_01_02def
Louis Stevens2023_01_02ghi
Louis Stevens2023_01_02jkl
Louis Stevens2023_01_02mno
Louis Stevens2023-01-09pqr
Louis Stevens2023-01-09stu
Ren Stevens2023-01-02abc

 

 

But in my gallery is is showing every week,

 

wonka1234_0-1699629524190.png

 

How can I show the distinct Week for each person? Instead of it replicating many times for each Project?

 

thanks

Categories:
I have the same question (0)
  • MudassarSZ365 Profile Picture
    591 on at

    Hi @wonka1234 ,

    To display distinct weeks for each person in your gallery, you should use the Distinct() function along with Filter(). Your formula would look something like this:

    Distinct(Filter('Scheduling List', 'Staff Name' = PersonID), Week)

    If you think my solution is helpful for you, then please accept it. 😊 Regards, Muhammad Mudassar Mazhar.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 70

#2
WarrenBelz Profile Picture

WarrenBelz 64 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 36 Super User 2026 Season 1

Last 30 days Overall leaderboard