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]

OK @kris_vin ,

That is why we are all struggling to get a solution.

Can you please let us know who you want to answer this - we can all help you.

[kris_vin]

Thanks @WarrenBelz .

I appreciate , if you can help me on this

Thanks

[WarrenBelz]

OK @kris_vin ,

I asked this as the solution is not simple on a Lookup column.

I am just back on line now due to time zone (8:30am here) so have now read your responses.

Firstly, a Lookup column is seeking the ID of the item referenced in the other list, so you cannot write multiple values to it that do not match the specs. What are you trying to do with this Lookup column and why do you need to write data different to what can be chosen in its Choices?

[v-xida-msft · Accepted solution]

Hi @kris_vin ,

Could you please share a bit more about the LookUp type column in your Main SP List? Do you enable "Allow multiple selections" option for this LookUp field in your Main SP list?

Does the LookUp field reference values from the Title field in your Categories SP List (second SP List)?

If you have enabled "Allow multiple selections" option for this LookUp field in your Main SP list, I think there is something wrong with your formula.

Please consider set the Update property of the LookUp field Data card in your Edit form to following:

ForAll(
       ComboBox1.SelectedItems,
       {
         Id: ID,
         Value: Title
       }
)

Note: I assume that the LookUp field references values from the Title field in your Categories SP List (second SP List)

In addition, please set the DefaultSelectedItems property of the ComboBox to following:

ForAll(
       ThisItem.LookUpField,
       {
         Title: Value,
         ID: Id
       }
)

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

Best regards,

[WarrenBelz]

Hi @kris_vin ,

I will leave you with @v-xida-msft here as they have responded.

I am not a user of these fields (I have in the past, but have abandoned them due to being able to do everything in Power Apps). 

@v-xida-msft is correct about the multiple selection option (which slipped my mind), as long as the values line up with what can be selected.

[kris_vin]

@v-xida-msft 

it worked !!!  Thank you so much !!! 

@WarrenBelz  Thanks for your help

[Anonymous]

Hey @v-xida-msft , it looks like this solution might also solve my issues withe the ComboBox. However, I get an error with ID row. It says: Name isn't valid. This identifier isn't recognized. Do you have an idea how to fix it?

Thanks in advance

[newpowerbiuser8]

Hi Warren,

If you could please help me:

 I have the same problem, the data is not being stored in SP and also when I edit the form the field becomes blank (Does not save previous data selected)

My SP is a multitext coumn. 

Items proerty of Combobox is: Sort(Filter(Distinct('Business Unit-Procedure Name',BusinessUnits),Not(IsBlank(Result))),Result)

What should be the update property of the data card?

What should be the default Selected items property of combobox?

Is there anything else I'm missing?

[WarrenBelz · Accepted solution]

Hi @newpowerbiuser8 ,

Data Card Update

ForAll(
   YourComboBoxName.SelectedItems,
   {Value: Result}
)

DefaultSelectedItems

ForAll(
   ThisItem.YourSPColumnName,
   {Result: 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

[newpowerbiuser8]

Warren! You're pure genius. Thank you so much. I had lost 2 nights over it! Also, I don't know how to accept this as a solution in this forum