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 / Cascading a dropdown t...
Power Apps
Unanswered

Cascading a dropdown to not show a blank value

(0) ShareShare
ReportReport
Posted on by 151

Hello,

 

So I am trying to have a cascading effect on two datacards. I need datacard2 to understand datacard1 when it is already pre-loaded. 

 

For example - Datacard2 has a formula on Default of Datacard1.selected.result. This would have Datacard2 display the selection from Datacard1. Works fine and dandy until Datacard1 is preloaded with data from a gallery and is not selected in the dropdown. then datacard2 does not see anything there. 

 

How can I make datacard2 see the selection of datacard1 when it is already preloaded?

 

thanks

 

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

    @Jakegolden 

    Can you explain further about what you mean by "preloaded"?

    If there is nothing selected in the first dropdown, then your formula on the second will show nothing either.  What is it that you want to show if nothing is selected?

     

  • Jakegolden Profile Picture
    151 on at

    hi @RandyHayes 

     

    So by preloaded I mean datacard1 is being populated from the gallery. The gallery is gathering data that has been stored to my sharepoint list.

    On the first go, the user is making a selection on datacard1. this info is then being submitted to a sharepoint list. The user will then come back at another time and open up the app, use the gallery to pull the info back from sharepoint to then populate my datacards. Basically I am using this method as a saving feature so they can return and fill out the datacards as they please. 

    But once the info is pulled out from the gallery onto datacard1, datacard2 no longer registering any data because nothing is being selected, because the data is already there. 

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Jakegolden 

    Yes, thank you.  By "datacard1 is being populated..." is this that the Items of the Dropdown are being populate and not the Default or that the Default is populated by it?

     

    Since you are mentioning a datacard, I am assuming then this is all in an EditForm.

    Can you supply the Items, and Default property formulas for the two dropdowns.

    Also, the Default and Update property for the two datacards that they are in?

  • Jakegolden Profile Picture
    151 on at

    @RandyHayes 

    Correct it is in an editform. The form Item is set to gallery.selected.

     

    DataCard1

    Items - Distinct(Sort('Project Name/Contact'.Projects,Projects),Projects) 

    Default - blank

    Update - DataCardvalue1.selected

    Default - Thisitem.project

     

    DataCard2

    Items - (perhaps my issue? this one specifically is just a text input, so no items property)

    Default - DataCardValue1.Selected.Result

    Update - DataCardvalue2.Text

    Default - blank

     

    So basically what I am trying to do is take the already selected project name from datacard1 and display it in datacard2. 

                    

  • Jakegolden Profile Picture
    151 on at

    @RandyHayes 

     

    So to make it another claim to giving an example with datacard2 having a dropdown as well instead of a text

     

    DataCard2

    Items - Sort(Filter('Project Name/Contact', Projects = DataCardValue1.Selected.Result).Contact,Contact)

    Default - DataCardValue1.Selected.Result

    Update - DataCardvalue2.Selected

    Default - blank

     

    So with this example I am trying to pull contacts that are associated with the selection in datacard1 

     

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Jakegolden 

    So you seems to be duplicating the value selected.  You have one datacard which is storing the Selected value from your dropdown, and then another that is storing the same selected item!?

     

    Your bigger issue comes from the first dropdown - DataCardValue1  You have nothing in the Default property!  That should be set to Parent.Default  otherwise it will have no value when you edit a record...and thus, your second dropdown will have nothing as well.

    Also, your Update property on DataCard1 should be: DataCardValue1.Selected.Result

     

    On DataCard2 you have a different issue!  Your first dropdown is doing a Distinct function on your Projects.  This will only give you a Result column in your items.  However (based on your last post) your second dropdown is based on the Contact from that same source.  And then, you are trying to set the Default to the selection in the first dropdown...which is a Project - not a Contact.  So, it will never match!

     

    My suggestion would be to do the following:

    On the DataCardValue1 Items property, set it to:

    Sort(
     GroupBy('Project Name/Contact',
     "Projects",
     "_data"
     ),
     Projects
    )

    Set the Default of the dropdown to: Parent.Default

     

    On DataCardValue2, set the Items property to:

    DataCardValue1.Selected._data

    Set the Default of that dropdown to: Parent.Default

    Also, the Default on DataCard2 needs to be the column you are storing that data into.  Ex. ThisItem.Contact or whatever the field name is.

     

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

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 993

#2
Valantis Profile Picture

Valantis 675

#3
11manish Profile Picture

11manish 545

Last 30 days Overall leaderboard