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
Advocate I
Advocate 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 Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

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 (5,539)