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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Drop Down Depends On I...
Power Apps
Answered

Drop Down Depends On Issue

(0) ShareShare
ReportReport
Posted on by

@RandyHayes 

 

Hi Randy,

 

I'm having a little trouble recreating the Depends On functionality in the Earth Day App.

 

Here is the Items property of the dropdown control from the Christmas version:

With({lclChoices: Choices('Holiday Raffle'.Party)},ForAll(Sequence(CountRows(lclChoices)+1),{Value:If(Value=1, "Select a Party", Last(FirstN(lclChoices, Value-1)).Value)}))


And here is the OnChange property:

If(Self.Selected.Value<>"Select a Party",Navigate('Raffle Screen', ScreenTransition.None))

 

Here is a snapshot of the Depends On box. It is difficult to see in the screenshot, but the Parent control reads ddShiftParties/Value and the Matching Field section reads Holiday Raffle/Value.

 

DependsOnss.png

 

I entered the Items and OnChange formulas into my Earth Day Raffle app, but here is the message I see when I click on the Depends on... link. I've been over the Christmas Raffle app with a fine tooth comb and don't see any hidden controls so I'm not sure how to resolve this. Can you help me? The outcome of this not working is that the user can select "Select a Party" and it leads to a blank raffle screen. This does not happen in the Christmas app. They are only directed to the raffle screen when they select a shift party which and there is no danger of running into a blank screen.

 

DependsOnEDss.png

 

Kind regards,

Teresa

Categories:
I have the same question (0)
  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @tagustin2020 

    The Depends on feature is not really of any value to you in this scenario.  Is there any particular reason for it that you feel?  Your Items are coming directly from the Holiday Raffle party column, so in your new app, you would be changing that to Choices('Earth Day Raaffle'.Party)

    There are no dependencies to be considered.  I would remove them.

     

    I hope this is helpful for you.

  • Verified answer
    tagustin2020 Profile Picture
    on at

    @RandyHayes 

     

    Hi Randy,

     

    Thank you for your assistance with my app. The final dropdown formulas were as follows.

     

    Items:

    With({lclChoices:Choices('Earth Day Raffle'.Party)},ForAll(Sequence(CountRows(lclChoices)+1),{Value:If(Value=1,"Select a Shift Party",Last(FirstN(lclChoices,Value-1)).Value)}))

     

    OnChange:

    If(Self.Selected.Value<>"Select a Shift Party",Navigate('Raffle Screen', ScreenTransition.None))

     

    Default:

    "Select a Shift Party"

     

    The blank screen issue stemmed from the fact that I had "Select a Shift Party" in one formula and "Select a Party" in others. You helped me spot this. Once I matched the phrase exactly in all 3 everything worked perfectly. 

     

    I'm sure our employees are really going to enjoy their Earth Day raffle. Thank you so much for your kind assistance!

     

    Happy Earth Day!

    Teresa

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 372 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 303 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 238 Super User 2026 Season 1

Last 30 days Overall leaderboard