News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Distinct only showing ...

Power Apps - Building Power Apps

Unanswered

Distinct only showing 1 value, expecting 2

(0) Share

Report

Report

Posted on by wonka1234

909 Super User 2024 Season 1

Hi,

I am using this formula - Distinct('Scheduling List', 'Staff Name')

but my gallery is only displaying one staff name. I have two in my list under the column Staff Name.

Why is it not retrieving both names?

Thanks.

All responses Img

All responses (4)

Answers Img

Answers (0)

wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Distinct only showing 1 value, expecting 2

bump
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Distinct only showing 1 value, expecting 2

bump
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Distinct only showing 1 value, expecting 2

@WarrenBelz in a row in vertical gallery. WEridly only the one name shows in the vertical gallery.

but my list has 2 names i am expecting.
WarrenBelz 146,605 Most Valuable Professional on at

Like (0)

Report
Re: Distinct only showing 1 value, expecting 2

Hi @wonka1234 ,

Your formula

Distinct('Scheduling List', 'Staff Name')

will show all distinct 'Staff Name' values in your 'Scheduling List' - how are you trying to display these ?