Power Platform Community Forum Thread Details

Building basic canvas app with 4 drop downs used to return multiple lines of data. Data source is a SP list.

Here is how my drop downs are set up

1. Employee Status

Sort(Distinct(DLHelper3,'Employee Status'),Result)

2. Division

Sort(Distinct(Filter(DLHelper3, 'Employee Status' = EmployeeStatus.Selected.Result),Division),SortOrder.Ascending)

3. Office Location

Sort(Distinct(Filter(DLHelper3, Division = DivisionDrop.Selected.Result),'Office Location'),SortOrder.Ascending)

4. Cost Center

Sort(Distinct(Filter(DLHelper3, 'Office Location' = OfficeLocation.Selected.Result),'Cost Center'),SortOrder.Ascending)

Boxes 1 & 2 return correct options as i would expect as seen from the data source. But once try to select a value from box 3, all values are available when there should only be a couple of options based off of box 1 & 2 selections. Same goes for box 4 - i see all values available rather then the few that should be filtered down after selecting 1, 2, and 3.

Thanks for any help anyone may have.

Categories:

Building Power Apps