Unanswered

How to filter a lookup field by another lookup field

(1) Share

Report

Posted on by AdrianChang

I have a power app form that there are 2 lookup fields

First one is about the machine model looking up the list below
ID Title
1 Model A

2 Model B

3 Model C

second one is about the option looking up the list below

ID Title
1 Option A

2 Option B

3 Option C

4 Option D

Model A can choose Option A and Option B only
Model B can choose Option B and Option D only
Model C can choose Option A, Option B and Option C only

How should I design the lookup list for Machine Model and Option? How to set the filter of lookup field in the power app form?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report
Hey @AdrianChang ,

The simplest way would be to create the table like this:
Model Option
Model A
Option A
Model A Option B
Model B Option B
Model B Option D
Model C Option A
Model C Option B
Model C Option C

Then you could use this function:
//in Second Dropdown Filter(ListName,Model=Dropdown1.Selected.Model)

Let me know if it helped you or if you need any further assistance.

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (1)

Report

I think of 3 Designs
First:
Machine Model List
ID Title Available Model
(Lookup to Option List)
1 Model A [Option A, Option B]
2 Model B [Option B, Option D]
3 Model C [Option A, Option B. Option C]
Option List
ID Title
1 Option A
2 Option B
3 Option C
4 Option D

Second:
Machine Model List
ID Title
1 Model A
2 Model B
3 Model C
Option List
ID Title Available Model
(lookup to Machine Model List)
1 Option A [Model A, Model C]
2 Option B [Model A, Model B, Model C]
3 Option C [Model C]
4 Option D [Model D]

Third:
Machine Model List
ID Title
1 Model A
2 Model B
3 Model C
Option List
ID Title Available Model
(lookup to Machine Model List)
1 Option A [Model A, Model C]
2 Option B [Model A, Model B, Model C]
3 Option C [Model C]
4 Option D [Model D]
Mapping Table
ID Model Option
1 Model A Option A
2 Model A Option B
3 Model B Option B
4 Model C Option A
5 Model C Option B
6 Model C Option C
7 Model D Option D

However, I don't know how to set the filter in power app form.
And I would like to use first or second design

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (1)

Report

@DBO_DV Your suggestion is same as my third design? 3 tables in total?

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report

My suggestion is to create just the one table I showed you. and use a filter in the Items property of your Dropdown.

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (1)

Report

Seems not work

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (1)

Report

I think I need to use my design, because I need all same option using the same ID. Option A in ID: 1, Option B in ID: 2, etc.
Do you have any suggestion how can I set filter in form for my design? I hope to use my first or second design.

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report

Okay so 2 things:
First: it's best not to use actual LookUp columns in Sharepoint Lists for Power apps. Those columns are still quite buggy and not easy too use. You can simulate the lookUp in Power apps without any problem. If you have the possibility to change that it would make your task much easier.

Second: Are you using a combobox? If so do you need to be able to select several models at once?

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report
For your first design, could you use something like this?
First(DataCardValue2.SelectedItems).Option

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to filter a lookup field by another lookup field

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates

Model	Option
Model A	Option A
Model A	Option B
Model B	Option B
Model B	Option D
Model C	Option A
Model C	Option B
Model C	Option C

ID	Title	Available Model (Lookup to Option List)
1	Model A	[Option A, Option B]
2	Model B	[Option B, Option D]
3	Model C	[Option A, Option B. Option C]

ID	Title	Available Model (lookup to Machine Model List)
1	Option A	[Model A, Model C]
2	Option B	[Model A, Model B, Model C]
3	Option C	[Model C]
4	Option D	[Model D]

Community site session details

How to filter a lookup field by another lookup field

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Apps

Featured topics

Product updates