Unanswered

Setting up cascading Dropdowns using multiple values

(0) Share

Report

Posted on by Greg27

782

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Greg27 782 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Hi Randy,

Enabled is a set as a Single line of text.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@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"))

Was this reply helpful? Yes No
Greg27 782 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Greg27 782 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Greg27 782 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No