You’re offline. This is a read only version of the page.
49
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?
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?
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.
Seems not work
@DBO_DV Your suggestion is same as my third design? 3 tables in total?
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
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:
Share
Report
All responses (
Answers (
//in Second Dropdown
Filter(ListName,Model=Dropdown1.Selected.Model)
Let me know if it helped you or if you need any further assistance.
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
