Power Platform Community Forum Thread Details

Hi. I am having a problem with a Power App.

The PowerApps data is from two SharePoint lists: list1 and list2.

“list1” contains data about some items.

“list2” contains data on people who made the items in list1.

One person can make many items.

In “list1” is a lookup field on ID of “list2” (in order to connect each item to a person).

In the app there is a gallery, “galItems”, for “list1” (the items).

I have a multiselect comboBox, “comboBoxPerson”, linked to “list2” (people) in order to filter the gallery by people (i.e. show only items made by selected people).

Items for “comboBoxPerson”:

list2

Items for gallery:

Filter(AddColumns(list1,"tmpId",FAMILY_NAME.Id),IsBlank(LookUp(ComboBoxPerson.SelectedItems,ID=tmpId))=false)

This works fine.

But I want to display more info in “ComboBoxPerson” (full name, date of birth or if that is blank year of birth). So I set “ComboBoxPerson” Items:

AddColumns(list2,"tmpId",ID,"comboPerson",FAMILY_NAME &", "& GIVEN_NAME&" "&"b."&If(IsBlank(dateOfBirth),Text(yearBirth),Text(dateOfBirth,"dd/mm/yy")))

And I set “comboBoxPerson” displayFields to comboPerson.

“comboBoxPerson” itself functions OK but galItems shows all items in list1 if one or any number of persons are selected in “comboBoxPerson”, if none selected then galItems is empty.

Can anyone tell me what I am doing wrong?

Categories:

Building Power Apps