Answered

Dropdown selection reset to the first option when submitting form

(0) Share

Report

Posted on by vanhuxley24

Why does the RCL 2 and RCL 3 resets to the first option whenever I select submit form. It then will patch the first selection in the database.

See below code for the check/submit:

OnSelect: SubmitForm(CaseForm); Patch('EWS Case Data',CaseForm.LastSubmit,{'RCL 2': 'RCL2-Main'.Selected.Result,'RCL 3': 'RCL3-Main'.Selected.Result})

below is the default/first option in the dropdown.

RCL 2 Code: Distinct(Filter('EWS RCL Categories','RCL 1' = 'RCL1-Main'.Selected.Value), 'RCL 2')

RCL 3 Code: Distinct(Filter('EWS RCL Categories','RCL 2' = 'RCL2-Main'.Selected.Result),'RCL 3')

the onselect/onchange value for these dropdown are "false"

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

vanhuxley24 60 on at

Like
a
(0)

Report
Copy link

Link copied!

I already did this before on version 1 of this app but it doesn't reset to the first option.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @vanhuxley24 ,

Why do you submit the form twice? What is the default mode of the Form? If you would like to update the two columns, you can modify Update properties of the Data Cards where include the two Dropdowns:

Update of RCL2 Data Card:

'RCL2-Main'.Selected.Result

Update of RCL3 Data Card:

'RCL3-Main'.Selected.Result

Patch function is unnecessary. And the reason is Items (data source) of the two dropdowns relies on the selection of RCL1 Dropdown, after once submission, the selected items will be the one set in Default or the first one if Default is blank.

Best regards,

Was this reply helpful? Yes No
Verified answer

vanhuxley24 60 on at

Like
a
(0)

Report
Copy link

Link copied!

I didn't know I can patch the dropdown results to the list without using the Patch function. Guess I learned new thing.

Form's DefaultMode: Edit

Anyway, so what I did is removed the patch function from the save button. However, it still resets to the first option, but.

Since you mentioned because the Default Property of the Dropdown is blank, I have set a variable in OnSelect Property of these dropdowns and, called the variable in the Default Property of the Dropdowns. This worked!

Thanks! But if you have better suggestion on this one, please let me know 🙂 otherwise. Thank you for your reply, it helped! It's recording the correct result in the List but I still see the dropdown reset to the first option when I submit the form. Which is weird

Was this reply helpful? Yes No