Search code examples
filteringmicrosoft-dynamicspowerappspowerapps-canvas

PowerApps Filter Dropdown A if Value Found in Dropdown B

I have 2 Dropdown controls, AvailableSeats and BookedSeats, both containing one Text value of SeatName.

I want to hide rows in AvailableSeats that are simply present (not selected) in BookedSeats.

How can this be implemented? Thank you in advance.

Solution

  • You can use Not(... in ...) in your filter.

    For example:

    Filter(
  AvailableSeats,
  Not(SeatName in BookedSeats.SeatName )
)