Problem with defaultselecteditem combobox

[Bunly11]

Hi all -

I am having trouble trying to set DefaultSelectedItems for a combobox.

Item is defaulted to a list "DrugClassificationList" and column is "HazardousCategory"

I have update as:

ComboBox2.Selected.HazardousClassification

I tried DefaultSelectedItems

{DrugClassification:ThisItem.DrugClassification}

but nothing is stored in the SharePoint list when I edit. 

I was trying link below which worked on another combobox but have been stuck on above. 

https://powerusers.microsoft.com/t5/Building-Power-Apps/Edit-form-to-have-a-comboxbox-default-value-...

Thanks in advance.

[RandyHayes]

@Bunly11 

Your selections will never match with that formula in the DefaultSelectedItems property (DSI).

The DSI MUST be a record that is identical to the Items property.

What exactly is your Items property?

[Bunly11]

hi @RandyHayes 

I have the SharePoint List "DrugClassificationList" defaulted as the items property. 

The Column I want to display is "HazardousClassification". 

I am able to select and write back to the SharePoint record but when I "Edit" the selected item is not defaulted. 

[RandyHayes · Accepted solution]

@Bunly11 

Yes, your Items property is going to be a table of full records from the datasource.

Your DSI property is a single record with a single column...this will not match.

If you ONLY need the HazardousClassification column and there is no need for any other columns to be referenced elsewhere in the app for that combobox, then change the Items property to:

DrugClassificationList.HazardousClassification

This will change the schema of your Items property to be a table with records that only contain ONE column...the HazardousClassification column.

Then change your DSI property to:

{HazardousClassification: ThisItem.DrugClassification}

This is a single record with a single column called HazardousClassification - which will now match your Items property schema and you will have the correct item selected and the form data should then submit properly and redisplay properly.

[Bunly11]

@RandyHayes Thank you! It worked. I just had to change to "Title" for some reason. Maybe because original name was Title then I renamed it? 

[RandyHayes]

@Bunly11 

Yes, you can never change a column name in SharePoint.  It will always retain the original name.  Even though it appears renamed in the interface, it is still the original name.  Best to always reference the original names in PowerApps - although it will honor the changed name in some places, in others it will not, so best to just go with the one that works.

Glad it is working now for you.