cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kris_vin
Regular Visitor

Combobox value is Not getting Saved in SharePoint List

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

 

22 REPLIES 22

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.

Thanks @WarrenBelz .

 

I appreciate , if you can help me on this

 

Thanks

 

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?

 

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

@v-xida-msft 

 

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

 

@WarrenBelz  Thanks for your help

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

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?

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

 

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,352)