Doesn't create collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a problem with collection creation.

I would like to create a collection in combo Box onChange.

This is my code for collection

ClearCollect(multiMember, Self.SelectedItems)

Even Though I select Items on the combo Box, my collection multiMember still empty.

The items in the combo box.

Distinct(Member, Member.DisplayName)

Column type person

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

The Distinct() function returns a table of nested records as below:

You should modify as below:

ForAll(Distinct(Member, Member.DisplayName),Value)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Thanks, for you answer, but this is what I came up with. But still doesn't work.
This is items:
If(!IsBlank(ComboBox1_1.Selected) && IsBlank(ComboBox1.Selected), Distint(Filter(colMember, DepartmentID in multi.ID,Member.DisplayName), !IsBlank(ComboBox1_1.Selected) && !IsBlank(ComboBox1.Selected), Distinct(Filter(colMember, DepartmentID in multi.ID && TeamID in multifilter.ID),Member.DisplayName), IsBlank(ComboBox1.Selected) && IsBlank(ComboBox1_1.Selected),colMember, IsBlank(ComboBox1_1.Selected) && !IsBlank(ComboBox1), Distinct(Filter(colMember, TeamID in multifilter.ID),Member.DisplayName),colMember)
from those Items I would like to put selected values to the collection:
ClearCollect(MultiMember, Self.SelectedItems)
And later filter gallery by the selected collection ID.
Filter(colMember, MemberID in multiMember.ID)
Here I got error that multiMember.ID name isn't recognized.
Also the collection multiMember is empty

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Not sure if you have try the direction I provided to solve your problem, something complext in your scenario I could not reproduce on my side, so only a direction I could provide for your reference.

I could only tell you that the following formula has something syntax wrong:

If(!IsBlank(ComboBox1_1.Selected) && IsBlank(ComboBox1.Selected), Distint(Filter(colMember, DepartmentID in multi.ID),Member.DisplayName), !IsBlank(ComboBox1_1.Selected) && !IsBlank(ComboBox1.Selected), Distinct(Filter(colMember, DepartmentID in multi.ID && TeamID in multifilter.ID),Member.DisplayName), IsBlank(ComboBox1.Selected) && IsBlank(ComboBox1_1.Selected),colMember, IsBlank(ComboBox1_1.Selected) && !IsBlank(ComboBox1), Distinct(Filter(colMember, TeamID in multifilter.ID),Member.DisplayName),colMember)

Further, you have multi conditions in your If() statement, which needs you to make sure the each result should be matched in a same data structure, otherwise the if statement does not work.

What's more, hope you could understand that we could not reproduce your issue because there are too many details and related collection.

I could only tell you that, for the Distintc() part, you need to use the ForAll() to evaluate the Value field so that the ComboBox Items could display display name of your Member field.

Was this reply helpful? Yes No