I have a list that has a column of type Lookup. I would like to limit the values that appear in the lookup dropdown when editing the list item. Is it possible to apply a filter to the dropdown based on other columns in the secondary list?
I hope this makes sense.
Solved! Go to Solution.
Yes, you can use a Filter in the formula for your Items of the Dropdown.
In General:
Filter(yourOtherList, someColumn = whateverYouWantForCriteria)
If it is based on a value in the current list, then just utilize that in your filter.
Ex.
Filter(yourList, ProductCategory = ThisItem.Category)
I hope this is helpful for you.
Yes, you can use a Filter in the formula for your Items of the Dropdown.
In General:
Filter(yourOtherList, someColumn = whateverYouWantForCriteria)
If it is based on a value in the current list, then just utilize that in your filter.
Ex.
Filter(yourList, ProductCategory = ThisItem.Category)
I hope this is helpful for you.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
214 | |
205 | |
86 | |
59 | |
38 |