Power Platform Community Forum Thread Details

I have a table (Qualified Users) with 3 columns

1 - Name (Primary)

2 - DeptName (lookup to Departments Table)

3 - UserName (lookup to Users Table)

I want to populate a combo box using UserName as the items in the list. The Items should update based on a filter on a second combo box call cbo (linked to Department Name table)

I inserted a Label to test. The label text is

LookUp('Qualified Users', DeptName.DepartmentName = cbo.Selected.DepartmentName).Name

This works great. When I change cbo values, the lable updates with the Qualified Name

I Insert another combo box and use for Items

Filter('Qualified Approvers',cbo.Selected.DepartmentName = DeptName.DepartmentName).DeptName

This returns records, however, however, the records are blank. I cannot figure out how to display the Name information that should be part of the record.

Regards

Dave

Categories:

Building Power Apps