Answered

Replacing Distinct with GroupBY

(0) Share

Report

Posted on by micha_a

Hi,

I have a gallery displaying only the name and I would also want to display Organisation underneath. The Gallery can be filtered by 4 combo boxes and I tried to change the coding from Distinct to GroupBy, but I am not sure how I can integrate the drop downs with GroupBy or whether there is another solution to just add another label underneath Name that will display the Organisation name?

This is how the code looks atm:

Distinct(SortByColumns(Filter('WEF CRM',

StartsWith(
'Full Name',
TextInput3.Text
),
IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || 'Stakeholder type'.Value= ComboBox1.Selected.Value,
IsBlank(ComboBox2.SelectedItems.Value) || IsEmpty(ComboBox2.SelectedItems) || Subtype.Value= ComboBox2.Selected.Value,
IsBlank(ComboBox2_1.SelectedItems.Value) || IsEmpty(ComboBox2_1.SelectedItems) || 'Best For'.Value= ComboBox2_1.Selected.Value
), "Title", If(SortDescending1, Descending, Ascending)), 'Full Name')

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @micha_a,

You mean you want to display the corresponding Organisation to the name?

If so, I think GroupBy() is easier,

GroupBy(SortByColumns(Filter('WEF CRM', StartsWith( 'Full Name', TextInput3.Text ), IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || 'Stakeholder type'.Value= ComboBox1.Selected.Value, IsBlank(ComboBox2.SelectedItems.Value) || IsEmpty(ComboBox2.SelectedItems) || Subtype.Value= ComboBox2.Selected.Value, IsBlank(ComboBox2_1.SelectedItems.Value) || IsEmpty(ComboBox2_1.SelectedItems) || 'Best For'.Value= ComboBox2_1.Selected.Value ), "Title", If(SortDescending1, Descending, Ascending)), 'Full Name',"NameGroup")

Inset a Label to display Organisation by settings its Text property as below:

Concat(ThisItem.NameGroup,Organisation,",")

Was this reply helpful? Yes No
micha_a 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft,

Thank you for your reply, much appreciated.

This is exactly what I tried with GroupBy, and unfortunately it returns this The function 'GroupBy' has some invalid arguments. I am not really sure what is wrong with the formula

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @micha_a,

Sorry for the mistake that you should refer to "Full Name" instead of the 'Full Name' in the GroupBy

GroupBy(SortByColumns(Filter('WEF CRM', StartsWith( 'Full Name', TextInput3.Text ), IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || 'Stakeholder type'.Value= ComboBox1.Selected.Value, IsBlank(ComboBox2.SelectedItems.Value) || IsEmpty(ComboBox2.SelectedItems) || Subtype.Value= ComboBox2.Selected.Value, IsBlank(ComboBox2_1.SelectedItems.Value) || IsEmpty(ComboBox2_1.SelectedItems) || 'Best For'.Value= ComboBox2_1.Selected.Value ), "Title", If(SortDescending1, Descending, Ascending)), "Full Name","NameGroup")//Here you should use the double quotes""

Was this reply helpful? Yes No
micha_a 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft ,

I actually replaced the "Full Name" with "Title" and it worked! Thank you!

The issues I am having now is that under Gallery 1 my name is duplicated as per the records in my list e.g. 4 records under my name, in Power Apps Gallery my name appears 4x as in the pic below . Distinct was doing the job for me and displaying the name only once, but is there a way with GroupBy? Same duplication for Organisation (Test) - attached pic below

Thank you ever so much!

Was this reply helpful? Yes No