cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnthonyPhan
Kudo Kingpin
Kudo Kingpin

Set Default Selection of Combobox

Hi All,

I have a "Single-Select" Combobox with the items populated by a collection called "WorkOrderTable". I would like to set the default selection using formulas but have been unsuccessfull. I tried setting the "Default" property with the formulars shown below:
image.png

 

 

However no default selection is shown: 

image.png

 

How do set the default selection of a combobox using formula?

14 REPLIES 14
Rayo
Frequent Visitor

@digitaldanlim26 This worked for me too. Thanks so much.

ramanujama
Helper I
Helper I

It is really simple.
Example you have an Employee table with columns: Id, Name

Suppose you have created a Combobox for email and selected A, B, C and saved it in database. When you load the page or comes again, you want those items to be selected as default, use below formula:

DefaultSelectedItems = Filter(Employees, Name in Split(EmailList,","))

Note: EmailList is coming from database (previously saved value)

Above formula selects items in combobox as well.

Thank you. This worked for me. I just took out the "Id:0," out. Also changed Value: "20" to Value: ThisItem.ColumnName .

This was to get the Saved value come up when Editing the SharePoint Item.

ALP1
Continued Contributor
Continued Contributor

Hi @ramanujama 

I have the same issue.

I record values form combobox into the column "region concernée".

The formula shows only the first record.

 

Filter(
    'centre de documentation';
    'Région concernée' in Split(
        dpd_recherche_etude.Selected.'Région concernée';
        ", "
    )
)

 

ALP1_0-1624404169438.png

I added a label to understand if my dropdown dpd_recherche_etude returns correct values and it did as you can see.

The formula is dpd_recherche_etude.Selected.'Région concernée'.

 

I made a screenshot from my SP list

 

ALP1_1-1624404478605.png

 

What am i forget ?

 

 

ALP1
Continued Contributor
Continued Contributor

I respond to myself, need to use 

RenameColumns(Split(dpd_recherche_etude.Selected.'Région concernée'; ",");"Result";"Value")

 

credits goes to Loading Multiple Default Selected Items into a Power Apps Combo Box — Fidelity Factory

 

ALP1_0-1624432367946.png

 

 

 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,606)