Setting up cascading Dropdowns using multiple values

[Greg27]

I have 2 Dropdowns and each uses its own SharePoint list. The first displays 3 values. The 2nd Dropdown should be based on the value selected in the first Dropdown, with the addition of making sure the "Enabled" field in the SharePoint List the 2nd Dropdown uses, is set to "Yes". Here is my function:

Filter(Available_DivisionChair,School=dd_DataCardValue1.Selected.School && Enabled="Yes")

It seems to be returning no value. If I remove the && Enabled="Yes", it returns all of the rows in the SharePoint list, but I get the Enabled, as well as the disabled ones and I don't want the disabled ones.

[RandyHayes]

@Greg27 

Is Enabled a text column or a Yes/No column?  If Yes/No, then remove the ="Yes" part of your formula.

I hope this is helpful for you.

[Greg27]

@RandyHayes 

Hi Randy,

Enabled is a set as a Single line of text.

[RandyHayes]

@Greg27 

What do you get when you change the formula to just isolate the Enabled column?

i.e.  Filter(Available_DivisionChair, Enabled="Yes")

How about letter case?  Is "Yes" really uppercase Y? Or is it "yes"?

Also, if there is any space padding issues, consider the following:

Filter(Available_DivisionChair,School=dd_DataCardValue1.Selected.School && StartsWith(Enabled, "Yes"))

[Greg27]

@RandyHayes 

If I change the function to:

Filter(Available_DivisionChair,Enabled="Yes")

I still get nothing in the Dropdown.

All of the Yes and No values begin with a capitol letter. Here is a screenshot:

I tried your function above and it still returned nothing. Here is also proof that my field "Enabled" is actually a Single line of text:

I did limit it to a maximum of 3 characters

[RandyHayes]

@Greg27 

Then the formula should be working from what I see.

Have you happened to make any changes to the list (i.e. changing the field type or character length) after you added the list to your app?  If so, make sure you are doing a refresh on the datasource in the designer.

As a last-ditch effort, you can also try to remove the datasource and add it back.

And as a real desparate attempt, create another dropdown control with the same Items formula - in case the dropdown has some how gotten confused.

[Greg27]

@RandyHayes 

That's what I thought. Not sure if this helps, but I have another question open because I had another issue with the same app, where I added a form and connected the same SharePoint List to it, had the form mode set to New, but when I ran it, the fields disappeared and said no data was available. Kind of like the form mode was Edit. So I deleted that form, added a new form and added the fields again as I couldn't figure out why it was treating the form like I was editing. Since things just seem to be acting weird with this app, I decided to delete the app and recreate it and see if the problem goes away. I will let you know.

[Greg27]

@RandyHayes 

I ended up deleting the app, waiting a day, and recreating it. I am no longer having the problem. Any suggestions on how to handle a solution on this?