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
Solved! Go to Solution.
Cannot see Result as the primary text in combo box. How to select that ?
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,