Forum Discussion
Remove/Clear the selected value from a combobox upon changing the value of another combobox
1. Select your Street combo box in the Power Apps studio.
2. Go to the "OnChange" property of the Street combo box and enter the following formula:
Reset(Location)
This formula will clear the selected value in the Location combo box when the Street combo box is changed.
3. If you want this to work for both new and edit forms, you can wrap the `Reset` function with an If statement that checks if the form is in edit mode.
For example:
If(EditForm.Mode = FormMode.New, Reset(Location))
This formula will clear the Location combo box only if the form is in the new mode. If it's in edit mode, the Location combo box won't be cleared.
4. Make sure you replace "EditForm" with the actual name of your edit form. You can do this by selecting your form and checking its properties.
Now, when you change the Street combo box in your form, it will clear the selected value in the Location combo box, but only in the new form. The edit form will not be affected.
wfrf92 Reset() will not remove/clear the value it will reset it to the ThisItem value... this will not work specifically in Editform where there will be a value already..
john john You are correct. Did you find a resolution to this using the modern combobox? It doesn't have the same properties as the classic version. Quite annoying. Once a value is selected, I cannot unselect it or clear the selections.
the above answer(reset(control)) clears the control visually but will not save the empty value on save of an edit form.. So amending the formula in the Update property of the data card worked for me in edit form, instead of blank or {} ..use
{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:-1, Value:"" }
