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 / Dropdown composed of S...
Power Apps
Unanswered

Dropdown composed of Switch of Choices

(0) ShareShare
ReportReport
Posted on by 29

Hi all,

 

I'm trying to create a dropdown A that, based on the option selected in a dropdown B, displays a different item list linked to a different Sharepoint list (for every option). I tried this code for "Items" in Advanced:

 

Switch(Dropdown2_1.Selected.Value;

"Resources";Choices([@'GB Resources'].Role);

"External resources";Choices([@'GB External resources'].Item);

"Goods";Choices([@'GB Goods'].Item))

 

But only get the yellow warning and an empty dropdown with every option. Does "Choices" function not work with Switch? Or there is another proper way to do this?

 

Thanks for your attention and help! 

Categories:
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hello @Puppet47, 
    it most have something relational between the two sources.
    like a lookup column
    So you can filter the second dropdown based on the first one's selected.

  • Puppet47 Profile Picture
    29 on at

    Hello @OussamaOsman  and thanks for the fast answer.

     

    But every source is a differet list (within the same sharepoint). In this case, can Filter works if Choices isn't?

  • Puppet47 Profile Picture
    29 on at

    I tried creating a new dropdown with simply "Choices([@'GB Resources'].Role)" but it also doesn't work. Maybe the problem is that Role column data is "text" and not "choices values"? Don't know what function can be used in that case though

  • Puppet47 Profile Picture
    29 on at

    Trying to reformulate the problem and attaching some screenshots: the idea is that, if you select Resources in the first dropdown, the second dropdown look for data in the respective Sharepoint list.

     

    I tried the code in the first post but, as I thought, it doesn't work because 'Choices' can't take data from 'Role' column, as they're text and not an option column. I tested with a 'Concat' function but it doesn't get data from that list (though its added as data source).

    Captura3.PNG
    Captura2.PNG
    Captura.PNG

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 224 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 189 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 126

Last 30 days Overall leaderboard