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 Dependency issue
Power Apps
Answered

Dropdown Dependency issue

(0) ShareShare
ReportReport
Posted on by 61

I am not sure why all my dropdowns work how I want them to - only showing the one or more corresponding option(s) that follow one another through each dropdown. Below is an example of how the dropdowns work except dropdown 5.

 

Dropdown 1 - External

Dropdown 2 - Consolidation 

Dropdown 3 - Financial Reporting

Dropdown 4 - Not Managed

Dropdown 5 - Funds Not Funds (2 options to choose from) but if you selected the last 4 that way then the only option in my list, in SharePoint, is Not Funds, but dropdown 5 is showing both when I only want it to show what corresponds to one another.

 

All the other dropdowns have the right selections depending on what you select except dropdown 5.

 

Dropdown 1 Items Code

Distinct(Category,Title)

Dropdown 2 Items Code

Distinct(Filter(Category, Title = Default_Group_Dropdown1.Selected.Result),'Account category 1 - Description')

Dropdown 3 Items Code

Distinct(Filter(Category, 'Account category 1 - Description' = Acct_Cat_1_Dropdown.Selected.Result),'Account category 2 - Description')

Dropdown 4 Items Code

Distinct(Filter(Category, 'Account category 2 - Description' = Acct_Cat_2_Dropdown.Selected.Result),'Account category 3 - Description')

Dropdown 5 Items Code

Distinct(Filter(Category, 'Account category 3 - Description' = Acct_Cat_3_Dropdown.Selected.Result),'Account category 4 - Description')

 

Any help would be greatly appreciated

Categories:
I have the same question (0)
  • Verified answer
    rb Profile Picture
    835 Super User 2024 Season 1 on at

    It seems like your filter conditions should be additive. Should the expressions not look something like this?

     

    Distinct(Category,Title)

    Distinct(Filter(Category, Title = Default_Group_Dropdown1.Selected.Result),'Account category 1 - Description')

    Distinct(Filter(Category, Title = Default_Group_Dropdown1.Selected.Result && 'Account category 1 - Description' = Acct_Cat_1_Dropdown.Selected.Result),'Account category 2 - Description')

    Distinct(Filter(Category, Title = Default_Group_Dropdown1.Selected.Result && 'Account category 1 - Description' = Acct_Cat_1_Dropdown.Selected.Result && 'Account category 2 - Description' = Acct_Cat_2_Dropdown.Selected.Result),'Account category 3 - Description')

    Distinct(Filter(Category, Title = Default_Group_Dropdown1.Selected.Result && 'Account category 1 - Description' = Acct_Cat_1_Dropdown.Selected.Result && 'Account category 2 - Description' = Acct_Cat_2_Dropdown.Selected.Result && 'Account category 3 - Description' = Acct_Cat_3_Dropdown.Selected.Result),'Account category 4 - Description')
  • FlatFish Profile Picture
    61 on at

    I love you. Thank you so much I was really having a brain fart moment. 

  • rb Profile Picture
    835 Super User 2024 Season 1 on at

    I love you too @FlatFish, brain farts and all.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard