Answered

Setting multiple default value for Combo Box bound to SharePoint Choice field

(0) Share

Report

Posted on by Chris Hammond

130

As per title, I have a Power App form where one of the data-cards is bound to a SharePoint CHOICE field. However, this is a multi-select field where more than one item can be chosen

From this community, I 've managed to set the default value for a single choice (https://powerusers.microsoft.com/t5/Using-PowerApps/Set-a-default-value-for-a-Sharepoint-Choice-field-mapped-to/m-p/129767/highlight/true#M1151)

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Id:0,
 Value:"ChoiceA"}

...but I want to be able to set MULTIPLE choices from the start

In other words... all the values are ON and then the user turns OFF the ones they don't want.

TYIA

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@BO55VXR

In this case you would be looking at the DefaultSelectedItems property of your ComboBox control.

If you set that property to:

Choices(YourList.YourColumn)

That will give you all the choices for that column selected by default.

I hope that helps you out.

Was this reply helpful? Yes No
Chris Hammond 130 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @RandyHayes

What about default selection of say 4 out 6 options

@RandyHayes wrote:
@BO55VXR

In this case you would be looking at the DefaultSelectedItems property of your ComboBox control.
If you set that property to:
Choices(YourList.YourColumn)
That will give you all the choices for that column selected by default.

I hope that helps you out.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(4)

Report
Copy link

Link copied!

@BO55VXR

You could do it several ways - if there is some criteria you can use to choose them, then you could use a Filter

Filter(Choices(yourList.yourColumn), Value=yourCriteria)

Or, you could set them hard-coded (ex.):

["choice1", "choice2", "choice4"]

Was this reply helpful? Yes No
Chris Hammond 130 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes wrote:
@BO55VXR

You could do it several ways - if there is some criteria you can use to choose them, then you could use a Filter
Filter(Choices(yourList.yourColumn), Value=yourCriteria)

Or, you could set them hard-coded (ex.):
["choice1", "choice2", "choice4"]

So easy when you know how ... Thanks.

Was this reply helpful? Yes No