Combobox not recognising selection when in edit mode

(0) Share

Report

Posted on by CFC1888

Hi all,

I'm creating my first powerapp and have been stuck for a couple of days with an issue that is driving me insane!

I have a combobox called cmbCompany which sits in a datacard called Company_DataCard1, I thought everything was finished since initial testing was good, items selected in the combobox are being updated successfully back to my sharepoint list (this is a sharepoint list form app rather than a straight out canvas app). When I open an already created record to edit, my combobox is still displaying the previously set value, however, when I hit the save button after editing something other than the combobox I'm getting an error message "Company is required" on the error label.

I'm assuming this is being caused by my defaultselecteditems value being set as [Parent.Default], but I'm not entirely sure. The Items property on the combobox is set as SortByColumns('Company List', "field_1", Ascending). Is someone please able to tell me where I'm going wrong? What should the defaultselecteditems property be set as?

Thanks in advance for any advice.....tearing my hair out here!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CFC1888 ,

The items you have not posted is the field name displayed in the combo box and the field name and type you are writing back to. You have also complicated this by creating your list directly from Excel (not the best idea) and therefore the underlying field names are field_x (number). Using as an example Title as the field name displayed in your Combo Box and Company as the field in the List and it is a Choice column (single choice), then the DefaultSelectedItems would be

{Title: ThisItem.Company.Value}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CFC1888 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Forgot to mention, if I go into the combobox and reselect an option I can then save successfully

Was this reply helpful? Yes No
CFC1888 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Warren, when you talk about the field name, are you talking about the DisplayFields property (mine is set as ["field_1"]) and the SearchFields (also set as ["field_1"]) ?

Was this reply helpful? Yes No
WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@CFC1888 ,

Then try

{field_1: ThisItem.Company.Value}

You need the field displayed in the Combo Box the first part and the list choice field you are reading from in the second part.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CFC1888 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help @WarrenBelz, I managed to work out a solution by adding {Company:Parent.Default} to the DefaultSelectedItems property of the combobox.
So that is working great now, however, I've noticed another combobox that is dependant on the Fabricator combobox has a similar issue, but the same fix applied before won't work. Would you mind casting your eye over the details please? This is now the final piece of the jigsaw so any help would be fantastic.

The cmbDetailer combobox is populated based on selections in the Fabricator combobox, however, cmbDetailer is coming up blank when opening existing records (the Sharepoint list has been populated successfully), so it appears the DefaultSelectedItems property is the issue again. I've provided a screenshot to show the properties of the datacard and combobox for the Detailer, are you able to advise what I need to add please? The field to be displayed in the combobox is Title but I also see the same contents in the table under field {Name}. How should I populate the DefaultItemsSelection on the combobox?

Was this reply helpful? Yes No
CFC1888 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Actually just worked it out, I had set the fields to {Name} instead of Title, all working great now. Thanks again!

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @CFC1888 ,

This is the detail provided which I will close the post with

Assuming:-

Your field in SharePoint is a single Choice column (not a Lookup) and is called Fabricator

Your Combo Box is called cmbFabricator and is a single choice displaying the field name Company (so cmbFabricator.Selected.Company is the valid output)
Update of (as posted)

{Value: cmbFabricator.Selected.Company}

updates the table field in the Choice field (Value) with the output of the Combo Box (Company), which is Text.

DefaultSelectedItems of cmbFabricator as posted

{Company: ThisItem.Fabricator.Value}

populates the name of the Table field displayed in the Combo Box Table (Company) with the value in the SP choice field (Fabricator.Value).

Was this reply helpful? Yes No