Clear a conditional drop down when the user changes the primary drop down. SPO list as a data source

(0) Share

Report

Posted on by rixmcx59

158

Hello all, first let me give a brief description of my form,

I created my app from a SPO list using the "Create an App" option, so I do not have the SharePoint Integration feature in PowerApps designer.
My app has conditionally hidden and conditionally required drop down and fields.

Here is my scenario,

The user changes the primary drop down in edit mode (new or edit mode)
this action hides a conditionally required drop down along with the value selected
this unnecessary value gets submitted

I am able to clear one of the text boxes by setting the default to "",

If(DataCardValue33.Selected.Value = "Choice1" Or DataCardValue33.Selected.Value = "choice4",Parent.Default,"")

however, this does not work on the drop down, I get an error because a record is expected.

how do I prevent the drop from storing the selected value when gets hidden and is no longer required because the user changed the primary category, maybe a condition in the OnSubmit to clear the unnecessary values?

Thanks for any help

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi@rixmcx59 ,

I have read your question, perhaps you can try changing the Drop Down in this way:

Set the Visible and Required of the Card to:

DataCardValue33.Selected.Value="Choice 1"||DataCardValue33.Selected.Value="Choice 4"

Then set up the DefaultSelectedItems of the Drop Down to:

If(DataCardValue33.Selected.Value="Choice 1"||DataCardValue33.Selected.Value="Choice 4",Parent.Default,Blank())

Here are the results of my tests:

When I select Choice 1 or Choice 4 in choices, the choice_2 appears, which displays the original data and is required.

But when I select Choice 2 in choices, the choice_2 will be hidden and the data will be clear.

I hope this will help you.

Best regards，
Rimmon Li

Was this reply helpful? Yes No
rixmcx59 158 on at

Like (0)

Report
Copy link

Link copied!

Thanks, this worked perfectly for me.

Was this reply helpful? Yes No