Issue with ComboBox when cascading

[SPS-DEV-22]

I have these comboboxes 

When I choose Activity > Community Plan

Project combobox  becomes visible.
then when I choose Project 1 then District 1 Project Name combobox opens, along with the Label ( Utilize....)

Here is where the problem is..

if I change the Activity to another item in the combobox

project disappears like it should.  however, district project name, label remain visible.

I need the comboboxes to disappear and reset to blank if the items are not visible. SharePoint saves what values are in the comboboxes even if they are not visible on the form.

I only need them visible when the Activity Dropdown = Community Plan

and the data within actually is selected and visible.  Additional info, there are 8 Projects and to each project has 4 Project names under that. and each one has a Label (Description)

Activity = Community Plan

Code for Project visibility:
If(DataCardValue10.Selected.Value="Community Plan",true,false)

Code for visible Project

If(DataCardValue19.Selected.Value="1",true,false)

label 

Code for label Visible:
If(DataCardValue21.Selected.Value="Geographic Deployment",true,false)

how do I get the above code to also clear the items if they are not visible?

if this does not make sense, please let me know.

[SPS-DEV-22]

@RandyHayes

Your guess is correct. I will need to change the Descriptions and Projects and the reason is, every three years the Projects/Project Descriptions change. the next change will be in June of '23.

I need to have the Project Descriptions, the visible property changes if the Activity Changes and the Project Name Changes.

currently the comboboxes do what I need them to do, the Project Descriptions will change based on the Project Name change,  however if I just go a change the Activity to something else, the Project Description remains.

I need the visibility of the description to change .

let me ask this :

would it be easier to go ahead and create the descriptions as text boxes in the SharePoint list and then do the visible like what was done to the comboboxes and then all I would have to do is change the SharePoint List text boxes?

[RandyHayes]

@SPS-DEV-22 

Well, I would have advised that your descriptions should be in your SharePoint List so that you are not having to update your app all the time.  But then you really would not want the Project Name to be a Choice column.  It should just be in its own list or brought into some existing list.

Otherwise, what I last provided you is the best method without any data changes.  Keep your description label visible and set the Items property as I showed and also make sure you are resetting the combobox from a higher level (the Activity).

If you do that, it will give you exactly what you are looking for.  And there is no need for any Visible property changes or multiple labels or any other complexity.

[SPS-DEV-22]

@RandyHayes

Since there really isn't a Golden Standard for when you are customize a SharePoint list form using PowerApps.

it is hard to know exactly how to start the development, what should be a SPS list column vs a Label in PowerApps.

so just make the 32 descriptions textboxes. either way 32 labels and or 32 textboxes.. 

Since I'm rebuilding this from an older app and I and or other people will be updating every 3 years. I will put the descriptions into a text box and pull them in that way. that way they can be generic. and make it easier to add and or drop the items.

I think I can repurpose some of the code you have assisted with, greatly appreciated. to show/hide descriptions and have them not visible when the activity changes and Project Name.

I will try to get ahold of you if I run into any issues.  

FYI:

prior to changing the descriptions to Labels in PowerApps, they were textboxes in SPS.. LOL

[RandyHayes]

@SPS-DEV-22 

Well, it's not even that complex.  It is really that you are going to replace the Choice column in your Community list.

The concept is that you start a Project list.

In that list, you would have the Project Name (usually just in the Title) and then a text column for the Description.

The only change in your Community list would be to add a ProjectID column (numeric) that you would then store the ID of the Project record from the new project list.  

Alternatively, you could store just the project name as text in the Community list, but it is preferable to be more exact - with the ID.  

And a final alternative is to make a Lookup column in your Community list to reference the new project list.  Lookup columns can be tricky for some, so use accordingly.

Your formula then for the Items of the Project Name combobox would then just change to be the new list name.

And then...back to where we left off in the prior formula for that Items property....

The ONLY thing we are changing from the formula I provided back in message #10 is that you are not hard-writing in the descriptions...they would be coming from the new list.

However, the concept of the label I described would still remain - it would always be visible and it would be based on the description column from the combobox selected record.

[SPS-DEV-22]

@RandyHayes

Ok, You said to use a SharePoint list column. I know it is a brain fart .. long day ...

the descriptions are LONG.   What SharePoint Column would I use, I'm not having any luck with the TEXTBox and using the Description and or the Default text. Just a Blank text Box Shows

[RandyHayes]

@SPS-DEV-22 

I know what you mean about a long day!!

So for the column, if the descriptions are long, I would just make sure they are multiline text columns in your list.

In the app, you would want to use the label and just set the Text property to the combobox.Selected.Description as mentioned back in post #10

[SPS-DEV-22]

@RandyHayes 

Quick question concerning this:

Activity:  Reset(yourProjectCombobox)

Project Combobox OnChange action: Reset(ProjectNameCombobox)

Can we reset a Label?

I got the issue resolved concerning the Label and the various switching with visibility.

[SPS-DEV-22]

@RandyHayes

What would cause a combobox to work when visible = true

choices are available.

and then this code
visible=DataCardValue21.Selected.Value="Problem"

and then when "Problem" is selected it becomes visible however the combobox stops working, no choices are available.

I have deleted and then readded the combobox. so that isn't the issue.

What would cause the combobox to stop working?

SOLVED:

It had something to do with where it was located at on the form, once I moved to a different location on form it started to work, strange but true.