cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Maja2
Frequent Visitor

Sharepoint Integration with Powerapps Forms- Unable to update multi select Combo box values to the existing values in a record

I'm new to Power apps. We are integrating the sharepoint list with the power apps form. I have single line text column in the sharepoint list. In Powerapps the input is a combobox with multi select enabled. When i use the form in new mode, the updates to the backend Sharepoint list happens seamlessly. However when the Form is in Edit mode, I have set the DefaultSelectedItems Property to 

 

If(SharePointForm1.Mode=FormMode.View,Table({Value: Parent .Default}),If(SharePointForm1.Mode=FormMode.Edit,RenameColumns(Split(ThisItem.'Functional Area',","),"Result","Value")))

 

The existing items for the record i'm editing is showing as selected in the combo box selected items. However, when i update the selection (Either add new selection or delete), the existing values are not captured and only the new values are captured. For eg: If the record has "Yellow, Red" selected, and if i select "Blue" in the combobox list while editing, the new updates happens as ",,Blue" instead of "Yellow,Red,Blue."

 

Update Property of the Data card: Concat(ComboBox4.SelectedItems,Result,", ")

Items for the multi Select Combo Box: Distinct(Colors,'Name')

 

Any help here is much appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
victorcp
Solution Sage
Solution Sage

Hi,

in your combobox the item has this schema {Result: ""} but the default schema is {Value: ""}, remove the renamecolumn and it should work.


If(SharePointForm1.Mode=FormMode.View,Table({Value: Parent .Default}),If(SharePointForm1.Mode=FormMode.Edit,Split(ThisItem.'Functional Area',",")))

View solution in original post

2 REPLIES 2
victorcp
Solution Sage
Solution Sage

Hi,

in your combobox the item has this schema {Result: ""} but the default schema is {Value: ""}, remove the renamecolumn and it should work.


If(SharePointForm1.Mode=FormMode.View,Table({Value: Parent .Default}),If(SharePointForm1.Mode=FormMode.Edit,Split(ThisItem.'Functional Area',",")))

Maja2
Frequent Visitor

Thanks @victorcp The above solution worked.

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 (1,326)