Lookup doesn't return all records from the SharePoint list column

[Iantaylor0290]

Hi,

I have a SharePoint list with columns location and group. In PowerApps UI, I have two dropdowns Location and Group.

When user selects a Location, the Group dropdown should automatically show all the values for that particular location.

I have written the below code in Group dropdown items property. However it shows only 1 Group (Group 2)

Location"IND- BNG Bangalore" is tied to 2 groups in SharePoint list. Any idea how to get the Group 3 in the dropdown ? PFB screenshots

LookUp(Employees,DataCardValue8_1.Selected.Result in 'Location Name:LocationName'.Value).Group

[Iantaylor0290]

Cannot see Result as the primary text in combo box. How to select that ?

[v-yutliu-msft · Accepted solution]

Hi @Iantaylor0290 ,

Have you set the two combo boxes' Items like what I recommended?

combo box's Items for LocationName:

Distinct(Locations,LocationName)

combo box's Items for Group:

Distinct(Employees,Group)

Then choose primary text here:

 

Best regards,