Asset Management App

[Omar_203]

Hello,

I am having difficulty trying to display a Distribution List in a gallery, based on a SharePoint People field. Essentially, I have a Combox Box dropdown with a list of employee names (Another SharePoint list Choices field). I want to be able to select a name from the dropdown and have the gallery display the DL name that user is a Member of.  I have tried the following, but no luck.

SortByColumns(Filter('Distribution Lists example', 'Current Owner'.DisplayName=ComboBox1_6.Selected.Value), "DLName", Ascending). 

The error is appearing with '=', message says: "Incompatible types for Comparison. Thes types can't be compared: Table, Text.

Although, I have another list called: "Account List" that uses a Person field and Combo Box dropdown, essentially the exact same, but this one works perfectly. see below.

SortByColumns(Filter('Account List Tracker','Current Owner'.DisplayName=ComboBox1_6.Selected.Value),"Title",Ascending).

What's the issue here, I am in need of help as I cannot figure this out.

Thanks.

[v-liwei-msft]

Hi @Omar_203 ,

Could you please tell me if you turned this option on when setting the person column？

If you open this option , PowerApp will report the error like your figure.

Beat Regards,

Levi

[Omar_203]

Hi Levi,

No problem.

The reason this option is enabled is because for a distribution list multiple people are 'members' of that DL.

Is there a workaround for this so, I can get this to work ?

[v-liwei-msft · Accepted solution]

Hi @Omar_203 ，

If you don't want to turn this option off, you can change function 

Filter('Distribution Lists example', 'Current Owner'.DisplayName=ComboBox1_6.Selected.Value)

to 

Filter('Distribution Lists example', ComboBox1_6.Selected.Value in 'Current Owner'.DisplayName)

Best Regards,

Levi