Unanswered

Distinct Filter Gallery

(0) Share

Report

Posted on by Phineas

5,331 Moderator

How do I turn the following into a distinct filter of the Gallery.

Goal: If the ComboBox is blank filter the list for all, but only one item of each, not all items of each.

A person may be on the list several times, but I only want to see each of their names once in the Gallery if the ComboBox is blank; Preferably the first record associated with their name.

The following returns all instances of all names in descending order if the ComboBox is blank, and all instances of ONLY the name chosen in the ComboBox if a name is selected. The second part of the formula is working; The first part should only return one instance of each person in descending order.

If(IsBlank(ComboBox1.Selected.Value),Filter(Collection,Title,SortOrder,Descending),
Filter(Collection,Title=ComboBox1.Selected.Value))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

HectorOlivos 411 on at

Like
a
(0)

Report
Copy link

Link copied!
Can you try with this

If( IsBlank(ComboBox1.Selected.Value), SortByColumns( Distinct(Collection, Title), "Title", SortOrder.Descending ), Filter(Collection, Title = ComboBox1.Selected.Value) )

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I've implemented your recommendation.

I don't get an error, but I don't get any ThisItem. options other than 'IsSelected', when I try to assign a column to a field.

My version of the formula allows me to apply the required columns to the Gallery fields.

If(IsBlank(ComboBox1.Selected.Value),
SortByColumns(
Distinct(Collection, Title),
"Title",
SortOrder.Descending
),
Filter(Collection, Title = ComboBox1.Selected.Value))

Was this reply helpful? Yes No