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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Lookup Dropdown Based ...
Power Apps
Answered

Lookup Dropdown Based on Value Selected

(0) ShareShare
ReportReport
Posted on by 442

How can I find the student names displayed based on the selected grade level?

Screenshot 2023-11-01 213528.png
Screenshot 2023-11-01 213443.png
Categories:
I have the same question (0)
  • Verified answer
    v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @dylandavis09 

    According to your description, you want to find the student names displayed based on the selected grade level.

    Here are the steps you can refer to :
    (1)This is my test data:

    vyueyunmsft_0-1698890774156.png

    (2)We can use this code in the "Full Name" Combo box -Items to filter the FullName table:

     

    Filter('Choices Test', 'L-Grade'.Value = ComboBox1.Selected.Value).'Full Name'

    If you want to multiple selection you can also use this :
    Filter('Choices Test', 'L-Grade'.Value in ComboBox1.Selected.Value).'Full Name'

    However, this does not support delegation, and you can decide whether you need it based on your actual usage.

     

     

    The 'Choices Test' is my SharePoint list name , you need to replace it in your side .

    vyueyunmsft_1-1698890898817.png

     

    The result is as follows:

    vyueyunmsft_2-1698890919260.png

    Best Regards,

    Yueyun Zhang

     

  • dylandavis09 Profile Picture
    442 on at

    Thank you so much for help! I have been figuring out. Lol

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

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 413

#2
WarrenBelz Profile Picture

WarrenBelz 355 Most Valuable Professional

#3
timl Profile Picture

timl 315 Super User 2026 Season 1

Last 30 days Overall leaderboard