web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to filter a lookup...
Power Apps
Unanswered

How to filter a lookup field by another lookup field

(1) ShareShare
ReportReport
Posted on by AdrianChang 53

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)
  • Daniel Bocklandt Profile Picture
    Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

    Hey @AdrianChang ,

     

    The simplest way would be to create the table like this: 

    ModelOption
    Model A

    Option A

    Model AOption B
    Model BOption B
    Model BOption D
    Model COption A
    Model COption B
    Model COption 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.

     

  • AdrianChang Profile Picture
    AdrianChang 53 on at

    I think of 3 Designs
    First:
    Machine Model List

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

    Option List

    IDTitle
    1Option A
    2Option B
    3Option C
    4Option D

     

    Second:

    Machine Model List

    IDTitle
    1Model A
    2Model B
    3Model C

    Option List

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


    Third:

    Machine Model List

    IDTitle
    1Model A
    2Model B
    3Model C

    Option List

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

    Mapping Table

    IDModelOption
    1Model AOption A
    2Model AOption B
    3Model BOption B
    4Model COption A
    5Model COption B
    6Model COption C
    7Model DOption 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

  • AdrianChang Profile Picture
    AdrianChang 53 on at

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

  • Daniel Bocklandt Profile Picture
    Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

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

     

  • AdrianChang Profile Picture
    AdrianChang 53 on at

    Seems not work
    AdrianChang_0-1720590876320.png

    AdrianChang_1-1720590908068.pngAdrianChang_2-1720590929830.png

    AdrianChang_3-1720591019593.png

     

  • AdrianChang Profile Picture
    AdrianChang 53 on at

    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.

     
  • Daniel Bocklandt Profile Picture
    Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

    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? 

     

  • Daniel Bocklandt Profile Picture
    Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

    For your first design, could you use something like this? 

    First(DataCardValue2.SelectedItems).Option

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#2
11manish Profile Picture

11manish 205 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans