Reset ComboBox not working

(1) Share

Report

Posted on by simms7400

829

Hi Folks -

I have a combo box called PFRPartnership.

I am running into an issue when a user selects a data element from the gallery that ALREADY has a value present for the Combo Box. The issue comes into play when the user backs out of that data element and selects a new Data Element from the gallery that DOES NOT have a value selected. Then if the user submits, even though that didn't pick a value for the Combo Box, it still updates the SharePoint list with the value from the previous data element.

How do I prevent this? This is causing major issues.

I tried Reset(PFRPartnership) but that doesn't seem to work. Where should I be putting that?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Is the combo box part of the gallery? What are the values for Default, Defaultselected and Itema property of the combo box?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
simms7400 829 on at

Like
a
(0)

Report
Copy link

Link copied!
@PowerAddict

The DefaultSelectedItems is:

If(DataCardValue128.Selected.Value = "No",Blank(),Filter(PartnershipList,Name=ThisItem.PartnershipID))
Default is blank.

Items is as follows:
Sort(PartnershipList,Alias,Ascending)

The ComboBox is part of the a Form. Users select a data element from the Gallery and are navigated to the Form.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

And what is DataCardValue128?

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Also what are you using to submit the form? SubmitForm or Patch?

Was this reply helpful? Yes No
simms7400 829 on at

Like
a
(0)

Report
Copy link

Link copied!

DataCard128 is just a "Yes" "No" field. If yes, the ComboBox field is displayed.

I use submit. Thank you!

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @simms7400

Since the form is inside a DataCard on a form, you need to use:

Reset(DataCardValue12)

Here, DataCardValue12 should be the name of the control that you want to reset. Note that the datacard name is different from the control name.

If this doesn't help, you can also set the configuration like:

Button to Reset -> Set(ResetControl,true);Set(ResetContol,false)
Control to Reset -> Reset property -> ResetControl

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
simms7400 829 on at

Like
a
(0)

Report
Copy link

Link copied!

@yashag2255 I'm not following your first suggest. And unfortunately, the second one does not work. Any ideas?

I put the Reset variable on the "OnVisble" of the EidtForm. Is that correct?

Was this reply helpful? Yes No
simms7400 829 on at

Like
a
(0)

Report
Copy link

Link copied!

@yashag2255

I put Set(ResetControl,true);Set(ResetControl,false) on the "Reset" property of my combobox.
Then I put ResetControl in the OnVisible property of my form.

Still doesn't reset 😞

Was this reply helpful? Yes No
simms7400 829 on at

Like
a
(0)

Report
Copy link

Link copied!

Again, the issue is when a user selects a data element from the Gallery and navigates to the EditForm where a value is ALREADY set for this ComboBox. Then, if the user goes back tot he gallery and selects a new Data Element that DOES NOT have a value selected for ComboBox, it will remembers the previous element and will put that value int he combobox upon Submit. Very annoying and causing lots of data issues.

Now, for the 2nd instance mentioned above, if I select a value, then clear the combo manually and then hit my reset form button, the ComboBox remember values from the previous form is removed.

How do i fix this??

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @simms7400

You need to put the variable on the "Reset" property of the combobox control, since this is inside the edit form, the name of control would be something like DataCardValue12.

Note: If the control is licked, please unlock the properties from the right menu first and then add it.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No