Combobox value is Not getting Saved in SharePoint List

[kris_vin]

Hi, 

I am facing an issue with PowerApps ComboBox control.

We are trying to change the SharePoint default form and create a PowerApps form. We have a combo box which is taking value from another list (I changed the item property of Combobox1 to this (SortByColumns(Filter(CategoryCollection, 'Content approval status'="Approved"), "Title", Ascending).Title) ). Combo box is working as expected , we can see the values based on the filtering criteria. 

However, When we save the data to the SharePoint list , Combobox1 value is not getting saved. 

Can anyone please help us?  Appreciate your help 

Please let me know if you need any additional information. 

Thanks

[WarrenBelz]

Hi @kris_vin ,

One question before I attempt a solution for you - what type of field is the target in your list (Text/Choice/Lookup/Other)?

[kris_vin]

@WarrenBelz  

Thanks for the reply. It's a Single Line text field 

FYI 

I am saving the second list values in a Collection and using the values from collection in the combobox  --- ClearCollect(CategoryCollection,Categories)

Thanks 

[WarrenBelz]

Thanks @kris_vin ,

This should be an easy one -

If the Items of the ComboBox are

SortByColumns(
   Filter(
      CategoryCollection, 
      'Content approval status'="Approved"
   ), 
   "Title", 
   Ascending
).Title

set the Update of the DataCard containing the ComboBox to

ComboBox1.Selected.Title

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.

[v-xida-msft]

Hi @kris_vin ,

Which column do you use as Display column value within the ComboBox? Title column?

Which type column do you use to store the ComboBox Selected value in your Main SP List? Choice type or Single Line of Text type column?

Please set the Items property of the ComboBox to following:

SortByColumns(
              Filter(CategoryCollection, 'Content approval status'="Approved"), 
              "Title", 
               Ascending
).Title

If you use Single Text type column to store the ComboBox Selected value, please set the Update property of the field data card (which contains your ComboBox) to following:

ComboBox1.Selected.Title

If you use Choice type column to store the ComboBox Selected value, please set the Update property of the field data card (which contains your ComboBox) to following:

{
  Value: ComboBox1.Selected.Title
}

Please consider take a try with above solution, check if the issue is solved.

Best regards,

[WarrenBelz]

Thanks @v-xida-msft for the addition to my solution.

[kris_vin]

Thanks @WarrenBelz

Unfortunately that didn't work. I changed the update property of the code to  ComboBox1.SelectedItems.Title    and it's still not saving data. 

-->Combo box is multi select enabled

--> Main SharePoint list field where I am saving this data is a LookUp column 

[kris_vin]

Thanks @v-xida-msft 

Which column do you use as Display column value within the ComboBox? Title column?

-->Title Column (

Which type column do you use to store the ComboBox Selected value in your Main SP List? Choice type or Single Line of Text type column?

-->LookUp Column 

I tried your solution, that didn't work. 

Thanks

[kris_vin]

@WarrenBelz  @v-xida-msft  @mdevaney 

I tried below code in the Update Property of the data card. Value is getting saved now, but the issue is, only one item is getting saved in the Main SharePoint list. Combo box is multi select enabled and when i try to save multiple items, only one item is saving. 

Main SharePoint list field where I am saving the combo box values is a LookUp column 

Combo-box data card Update property 

{

    '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    Id:Text(ComboBox1.Selected.ID,"[$-en-US]0"),

    Value:ComboBox1.Selected.ID

}

Thanks 

[kris_vin]

@WarrenBelz 

I am so sorry. I gave a wrong answer for your question. Target Field is lookup 

Thanks