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

ComboBox MultiSelect Update only adds new selections

Hi,

 

In my SharePoint PowerApps form, I have a ComboBox that updates a Choice column called Rooms (multiselect and user fill-in are enabled on both).  I want users to update the column with added items (e.g. initial column value was Room 101, and the user can add 102 and 103 later). In this scenario, I have it working where the form pops up with the Room 101 already selected in ComboBox.  The user can select the additional rooms - it appears that now 101, 102, and 103 are selected.  On save, column updates to 102 and 103 only.  Are either my default or update formulas incorrect?

 

DataCard Properties

DefaultForAll(ThisItem.Rooms,{Value:Value})
UpdateForAll(
Rooms_combobox.SelectedItems,
{Value:Result}
)

 

ComboBoxProperties

DefaultSelectedItemsForAll(ThisItem.Rooms,{Value:Value})

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @TrueBlue008 ,

 

You could set Datacard Default property to:

ThisItem.Rooms

 

Set Datacard Update property to:

your combo box control.SelectedItems

 

Set combo box control's Items property to:

Choices([your list.Rooms)

 

Set combo box control's DefaultSelectedItems property to:

Parent.Default

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

View solution in original post

v-xiaochen-msft
Community Support
Community Support

Hi @TrueBlue008 ,

 

This is because the column names are different.

The column name of the items formula is Result.

vxiaochenmsft_0-1623895908173.png

 

But the column name of the Default formula is Value.

vxiaochenmsft_1-1623896020381.png

 

So you should rename the column name.

vxiaochenmsft_3-1623896127036.png

vxiaochenmsft_2-1623896109940.png

 

Please modify the following two formulas:

RenameColumns( Sort(Distinct(GEDCS_TCF03Rooms,Title), Result, Ascending)),"Result","Value")
ForAll(
Rooms_combobox.SelectedItems,
{Value:Value}
)

vxiaochenmsft_4-1623896222792.png

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

 

 

View solution in original post

5 REPLIES 5
v-xiaochen-msft
Community Support
Community Support

Hi @TrueBlue008 ,

 

You could set Datacard Default property to:

ThisItem.Rooms

 

Set Datacard Update property to:

your combo box control.SelectedItems

 

Set combo box control's Items property to:

Choices([your list.Rooms)

 

Set combo box control's DefaultSelectedItems property to:

Parent.Default

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

View solution in original post

Hi Wearsky,

 

I did everything except update the Items property (I'm pulling from another List using Sort(Distinct(RoomsList,Title), Result, Ascending)).

 

However, now on save it's not updating at all.

v-xiaochen-msft
Community Support
Community Support

Hi @TrueBlue008 ,

 

This is because the column names are different.

The column name of the items formula is Result.

vxiaochenmsft_0-1623895908173.png

 

But the column name of the Default formula is Value.

vxiaochenmsft_1-1623896020381.png

 

So you should rename the column name.

vxiaochenmsft_3-1623896127036.png

vxiaochenmsft_2-1623896109940.png

 

Please modify the following two formulas:

RenameColumns( Sort(Distinct(GEDCS_TCF03Rooms,Title), Result, Ascending)),"Result","Value")
ForAll(
Rooms_combobox.SelectedItems,
{Value:Value}
)

vxiaochenmsft_4-1623896222792.png

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

 

 

View solution in original post

That fixed it thank you

TAutomate
Frequent Visitor

@v-xiaochen-msft  How would I achieve the exact same functionality using a lookup column in Dataverse instead of choices in sharepoint? Thanks for your help.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,486)