2

I have an app built based on the a SharePoint list called "Proposal Tracker". One of the fields is a lookup field that provides a drop down from another list called "Employees". I am trying to filter this field, so that when I select it, the only employee names that are shown are the "active" employees.

I've tried adding this into the DataField of the one data card I'm trying to filter, but I get an error.

Filter(Employees,Status.Value = "Active")
Kate Orlova
  • 3,225
  • 5
  • 11
  • 35
kriand0322
  • 21
  • 1

2 Answers2

0

Use Filter(CollectionName,Condition)

e.g: Filter(Employees,Status = "Active")

Karan Rana
  • 638
  • 4
  • 14
0

When you have a dropdown control selected you can choose its dependencies from other controls on the screen.

Example:

PowerApps screenshot

Murilo Santana
  • 615
  • 1
  • 7
  • 13