Unanswered

DropDown List reverting to default

(0) Share

Report

Posted on by Community Power Pla...

I have a Form connected to an Excel file stored in a Onedrive. The form has dropdown lists with Yes, No, and N/A and the Yes is set as the default. When the Save button is clicked the value should write to the appropriate cell on the Worksheet and show the new value as the one selected in the Dropdown. The data writes back to the excel sheet but when saved the Dropdown continues to revert back to Yes. I saw this was identified as a bug in an earlier release but my app is on 2.0.681. Is this still an identified issue? I need answers ASAP please. Thanks all.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Hi ChrisMancini,

Thanks for feedback.

According to your description, I create an app based on Excel table to test this issue.

On the EditForm, there is a Dropdown control with Yes, No, N/A. I set Yes as the default value.

When click the SubmitForm button, the value I selected will be saved to the Excel table without error.

While when I select an item and navigate from the BrowseGallery screen to the EditForm screen, I found that the value in the Dropdown is the default value “Yes” but not the one I selected before.

Then I try to set the Default value of the Dropdown as BrowseGallery1.Selected.YES_x002f_NO, the issue won’t occur. The value on the EditForm screen will be what I saved.

Please try it on your side. Hope this could be a workaround.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
ChnErl Microsoft Employee on at

Like (0)

Report

Hello,

I have also similar problem in my app. I am using CDS to save my data. In my form i have 2 dropdown which their vaues are Picklists. One of the dropdowns are working fine while saving the data. But otherone is reverting to default one. Its not a big issue for me for now because when it is saving that value is correct in database. I am displaying the status of this record while saving. In there it shows always the default option. Is there a way to lock dropdown selection or preventing this revert ?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

When I attempt your approach it doe retain the new value after the initial save. However, when I return to the form the currently saved value is not picked up from the excel sheet. Do you find the same experience?

Was this reply helpful? Yes No