cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrstian89
Helper IV
Helper IV

Filter based on a LookUp column

Hi!
I have a question regarding filtering items for a dropdown based on a lookup column in Dataverse.

 

I have the following tables in Dataverse:

1. Locations

2. Departments

 

In the department table i have created a LookUp column, pointing to the locations table, as a way to connect the department to a specific location.

 

I want to filter a dropdown based on location. I want to show all the departments connected to a specific location (chosen from a dropdown).

 

Filter('App - Departments',Dropdown1_1.Selected.Location in Department)

The code above works on regular columns, but not on LookUp columns.


Any suggestions? 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
mrstian89
Helper IV
Helper IV

Filter('App - Departments',Location.Location = Dropdown1_1.Selected.Location).Department

Solved it.

View solution in original post

1 REPLY 1
mrstian89
Helper IV
Helper IV

Filter('App - Departments',Location.Location = Dropdown1_1.Selected.Location).Department

Solved it.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,724)