Display result from Dropdown menu only when value from it is selected

Like (0) Share

Report

Posted on 8 Jan 2020 13:04:22 by oappdev

901

Happy Wednesday!

What is the best approach to only show result per Dropdown once selected. Right now when the user select "CatedoryDrp" it automatic populate "SubCategoryDrp","Product Name"

Here is what l'm using now to populate the Dropdown

CatedoryDrp

Distinct('PB Data',Category)

SubCategoryDrp

Distinct(Filter('PB Data',Category=CategoryDrp.Selected.Result),SubCategory)

Product Name

Distinct(Filter('PB Data',SubCategory=SubCategoryDrp.Selected.Result),Concatenate(Item," ",ProductName))

I hope i explain correctly

Thank you in advance

Categories:

General Questions

All responses (10)

Answers (1)

oappdev 901 on 09 Jan 2020 at 16:37:45

Like (0)

Report

Re: Display result from Dropdown menu only when value from it is selected

Thank you so much for your help @mdevaney
mdevaney 29,987 Super User 2025 Season 1 on 09 Jan 2020 at 16:32:15

Like (1)

Report

Re: Display result from Dropdown menu only when value from it is selected

@oappdev

Delegation was my thought too. I am glad you were able to solve the problem.

Best of luck building your app!
oappdev 901 on 09 Jan 2020 at 12:56:40

Like (1)

Report
Re: Display result from Dropdown menu only when value from it is selected

Happy Thursday @mdevaney
I fixed it was a "Delegation warning"

Trying to figure out why the third drop-down the data is showing without the user selecting the first and second drop-down

Code for "Product Name"
Distinct(Filter('PB Data',IsBlank(SubCategory)=true Or SubCategory=drpSubCategory.Selected.Result),Concatenate(Item," ",ProductName))
mdevaney 29,987 Super User 2025 Season 1 on 09 Jan 2020 at 00:53:48

Like (0)

Report

Re: Display result from Dropdown menu only when value from it is selected

@oappdev

What is the error message you are receiving here? I see the warning symbols but not the message. This will help me to diagnose what is going on.
oappdev 901 on 08 Jan 2020 at 15:10:48

Like (0)

Report
Re: Display result from Dropdown menu only when value from it is selected

@mdevaney
I using the following code that enable the [ ADD ] button.
DisplayMode
If(IsBlank(SubCategoryDrp.Selected.Result) || IsBlank(ProductNameDrp.Selected.Result), DisplayMode.Disabled,DisplayMode.Edit)

But i just want the [ ADD ] to enable when they only select "Product Name" drop-down
i'm using the code
If(IsBlank(ProductNameDrp.Selected.Result),DisplayMode.Disabled,DisplayMode.Edit)
Is giving me an error
mdevaney 29,987 Super User 2025 Season 1 on 08 Jan 2020 at 14:24:55

Like (0)

Report

Re: Display result from Dropdown menu only when value from it is selected

@oappdev

Yes, you can. I will let you know whether or not I have an idea of the solution.
oappdev 901 on 08 Jan 2020 at 14:14:43

Like (0)

Report
Re: Display result from Dropdown menu only when value from it is selected

Thank you so much @mdevaney
This did the trick
SubCategoryDrp
Distinct( Filter( 'PB Data', IsBlank(Category)=true OR Category=CategoryDrp.Selected.Result ), SubCategory )
Product Name
Distinct( Filter( 'PB Data', IsBlank(SubCategory)=true OR SubCategory=SubCategoryDrp.Selected.Result ), Concatenate(Item," ",ProductName) )

Can i ask a part 2 question?
mdevaney 29,987 Super User 2025 Season 1 on 08 Jan 2020 at 13:58:10

Like (0)

Report
Re: Display result from Dropdown menu only when value from it is selected

@oappdev

Awesome. I'm thinking this will work

IsBlank(Category)=true OR Category=CategoryDrp.Selected.Result

But in case it shows as a 0 character string instead you could also try this

Category="" OR Category=CategoryDrp.Selected.Result

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
oappdev 901 on 08 Jan 2020 at 13:55:00

Like (0)

Report

Re: Display result from Dropdown menu only when value from it is selected

You rock @mdevaney Will give it a try and circle back 🤓
Verified answer

mdevaney 29,987 Super User 2025 Season 1 on 08 Jan 2020 at 13:52:34

Like (2)

Report
Re: Display result from Dropdown menu only when value from it is selected

@oappdev

I think the most straightforward way to do this would be to have a blank cell as the 1st row in 'PB Data' for SubCategoryDrp and ProductName.

SubCategoryDrp

Distinct( Filter( 'PB Data', IsBlank(Category)=true OR Category=CategoryDrp.Selected.Result ), SubCategory )

Product Name

Distinct( Filter( 'PB Data', IsBlank(SubCategory)=true OR SubCategory=SubCategoryDrp.Selected.Result ), Concatenate(Item," ",ProductName) )

If the blank value does not appear 1st I believe you could apply a SORT function to make it go to the top!

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."