Cascading a dropdown to not show a blank value

[Jakegolden]

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

[RandyHayes]

@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]

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]

@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]

@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]

@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]

@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.