web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter + Distinct Form...

Power Apps

Unanswered

Filter + Distinct Formula in BrowseGallery issue

(1) Share

Report

Report

Posted on by wonka1234

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 Name	Week	Project
Louis Stevens	2023_01_02	abc
Louis Stevens	2023_01_02	def
Louis Stevens	2023_01_02	ghi
Louis Stevens	2023_01_02	jkl
Louis Stevens	2023_01_02	mno
Louis Stevens	2023-01-09	pqr
Louis Stevens	2023-01-09	stu
Ren Stevens	2023-01-02	abc

But in my gallery is is showing every week,

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

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

MudassarSZ365 591 on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No

Join the conversation