Combo box value displays value but when I try to write to database it returns NULL

(0) Share

Report

Posted on by lesotho_kid

106

Hello,

We have a combo box which does not allow for multiple selections.

The DefaultSelectedItems is set to:

If(EditForm_Checklist.Mode=New,{Value:"...Select a value"}, {Value:ThisItem.LGL_Checklist_CompanyName})

The Update of the card is set to:

cmbCompanyName.Selected.Result

This displays the correct record (either '...Select a value' or the previously selected item) - but when user clicks the save button - PowerApps does not recognize the field and thinks it is blank. Does not read the selected value. Strangely, if the user then reselects the same value from the dropdown box (the one that already appears) then it works. This worked properly last week and we have not made any changes to the app.

Any help appreciated,

Thanks - Dan

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Florian_Kleinz 227 on at

Like (0)

Report
Hi Dan,

ComboBoxes can be a pain in the ass because technically they return tables instead of single values like dropdowns.
So if ComboBox.Selected.Value does not work maybe you can use:
First(ComboBox.SelectedItems).Value
Combobox.SelectedItems returns a table with all selected values (in your case it is only one because multiselect is disabled.

Please let me know if this works.

Best regards
Florian

Was this reply helpful? Yes No
lesotho_kid 106 on at

Like (0)

Report

Thanks Florian! Appreciate your assistance with this.
Unfortunately, that did not work either. It actually worked the same way as the first method - where it doesn't work the first time the page opens - but if you reselect the same value - then it works.
I may just try deleting and re-adding it - unless you have any other ideas.

Thanks,
Dan

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
Hi @lesotho_kid ,

Could you please show more details about the formula you typed within the Items property of the cmbCompanyName?

Further, do you type a Distinct formula within the Items property of the cmbCompanyName?

Regarding the issue that you mentioned, I think you have typed Distinct formula within the Items property of the cmbCompanyName, right?

Based on the formula that you mentioned, I think there is something wrong with it. Please consider modify the formula within the DefaultSelectedItems property of the ComboBox to following:

If( EditForm_Checklist.Mode = FormMode.New, { Result: "...Select a value" }, { Result: ThisItem.LGL_Checklist_CompanyName } )

Please try above solution, check if the issue is solved.

Regards,

Was this reply helpful? Yes No