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 / dependent dropdown
Power Apps
Unanswered

dependent dropdown

(0) ShareShare
ReportReport
Posted on by Abhilash M abi 106

i'm having two dropdown.. one is showing from dealer table.... 2nd dropdown is from dealer user mapping table....

now i want to show User who is mapped to dealer selected in 1st dropdown....

1st dropdown item formula: Filter('Dealer Masters', 'Dealer Masters (Views)'.'Dealer Master Lookup View')

 

in 2nd dropdown i tried this formula: 

 

Filter('Dealer User Mappings', 'Dealer User Mappings (Views)'.'Dealer User Mapping Lookup View','Dealer Master ID'.'Dealer Code'=DataCardValue18.Selected.'Dealer Code')

 

but i'm getting Dealer mapping id... i tried somany ways to get User... i didn't get...

 

now i want to show user who is mapped to dealer which is selected in 1st dropdown...

help me.. 

 

Categories:
Building Power Apps
  • eka24 Profile Picture
    eka24 20,925 on at

    On the second dropdown items

    Filter (Datasource,dealeruser=Dropdown1.Selected.ColumnIn1stDropdown)

     

    If you have issues show screenshot of Items of all the Dropdowns

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Abhilash M abi Profile Picture
    Abhilash M abi 106 on at

    i tried this formula-- Filter('Dealer User Mappings','Dealer User Mappings (Views)'.'Active Dealer User Mappings','Dealer Master ID'.'Dealer Code'=DataCardValue16.Selected.'Dealer Code')

     

    i'm getting dealer user mapping  id only but i wan't to display Username... I checked in properties also there it has only dealer user mapping  id  and status code....

     

    refer the screenshot

    there why i don't have user ID as an primary text?? 

    Screenshot (40).png
  • v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    Hi @Abhilash :

    Could you tell me:

    • Have you tried @eka24 's solution?what's the result? Did the app report an error?
    • What is 'Dealer Master ID'?
    • What is the mapping relationship between'Dealer Masters' and'Dealer User Mappings'?
    • Could you provide details of the data structure of the data source?(CDS or SharePoint?Field name?Field Type?Which field in which table?Relation Ship?)

    Because I am not quite sure what your specific situation is, I can only provide the following connection for your reference:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup#syntax

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-by-lookup-field/td-p/9001

    If the problem persists, could you provide more details?

    Best Regards,

    Bof

     

  • Abhilash M abi Profile Picture
    Abhilash M abi 106 on at

    1st dropdown is from dealer master table... another dropdown is from dealer user mapping it has relation with dealer master and User table..

    every dealer has allotted one user... now i want to show user who is alloted to 1st dropdown selected dealer 

    Screenshot (41).png
    Screenshot (42).png
  • v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    Hi @Abhilash :

    Please try this code:

     

    DataCardValue16.Selected.'dealer user mapping'

     

    You can use this code to get the record in the'dealer user mapping' associated with the record selected by dropdown1.

    Best Regards,

    Bof 

  • Abhilash M abi Profile Picture
    Abhilash M abi 106 on at

    i used the below formula: Filter('Dealer User Mappings','Dealer User Mappings (Views)'.'Active Dealer User Mappings','Dealer Master ID'.'Dealer Code'=DataCardValue16.Selected.'Dealer Code' )

     

    i'm getting "Dealer user Mapping ID" but i wan't to display User ID.... in properties of dropdown it's not showing...???????

  • v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    Hi @Abhilash :

    Because "User ID" is a look up field.

    Try:

     

    Lookup('Dealer User Mappings','Dealer User Mappings (Views)'.'Active Dealer User Mappings','Dealer Master ID'.'Dealer Code'=DataCardValue16.Selected.'Dealer Code' ).'User ID'

     

    Best Regards,

    Bof

  • Abhilash M abi Profile Picture
    Abhilash M abi 106 on at

    LookUp('Dealer User Mappings','Dealer User Mappings (Views)'.'Active Dealer User Mappings','Dealer Master ID'.'Dealer Code'=DataCardValue16.Selected.'Dealer Code').'User ID'  

     

    i tried this but invalid argument error

  • Abhilash M abi Profile Picture
    Abhilash M abi 106 on at

    i changed to this formula: LookUp('Dealer User Mappings','Dealer Master ID'.'Dealer Master ID'=DataCardValue16.Selected.'Dealer Master ID').'User ID'   i'm getting what i wan't  but while submitting form it is showing error.... i'm using "submit(Form1)" to submit

  • v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    Hi @Abhilash :

    Please try to modify this data card‘s update property：

    For example:

    1.JPG

    LookUp('Dealer User Mappings','User ID'.'XXXX'=thedropdown.Selected.'XXXX')

    Best Regards,

    Bof

     

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 September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 225

#3
M Bilal Khan Profile Picture

M Bilal Khan 192

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