Answered

Powerapps ComboBox Patch to SharePoint List Clearing Values

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

Looking for some guidance. I have customized a SharePoint list form using PowerApps. My form is in EditForm mode. I have a combobox that allows multiple selections. The items of the combobox are derived from a separate SharePoint list as the datasource. On navigation to the next screen I Patch the SelectedItems of the combobox to a multiple select lookup column in the SharePoint list. This functionality works upon the selection of the items and the initial patch. However, once the data is persisted in the list if I edit the item once more and attempt to navigate, without changing any values in the combobox it patches empty values to the list - thereby overwriting the originally saved values. Also if I edit again and add a new value to the existing selected items it overwrites the values with only the newest addition. The DefaultSelectedItems are set to ThisItem.XXXXX.

Can someone help me out?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I solved my own problem. My issue stemmed from the value of the DefaultSelectedItems property. Because the actual values for the combo box are derived from a separate list, I had to filter the current items selected values and properly reference the value field of the combo box.

Thanks!

Was this reply helpful? Yes No
WarrenBelz 156,299 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,
I assume you are using SubmitForm in the Edit and there is nothing in the Combo Box showing at the time?
If you are never updating from this control other than the Patch, try removing the Update properties of the DataCard it is contained in. If you are updating from the card (note YourPresentValue below refers to what is working there now) - try
If( IsEmpty(YourComboBox.SelectedItems), ThisItem.YourFieldName, YourPresentValue )

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz , Thank you for your help. Actually I ultimately gave up on trying to use SubmitForm to submit the multi-select lookup values. I have yet to see a complete solution for having a secondary list to display lookup values that populate a multi-select lookup column in the source list. I believe that because the datasource of the combobox is not referencing the same datasource as my form it fails to properly update. Ultimately the issue was due to the DefaultSelectedItems of the combobox. I had to modify the DefaultSelectedItems to re-populate the persisted values using a Filter() function. Once properly re-populated the Patch statement would save the existing values, as well as any new selections that were made. I hope this makes sense I am not the best at describing the circumstances. Either way thank you for your response, if I get time I may take another go at SubmitForm.

Was this reply helpful? Yes No