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:
However no default selection is shown:
How do set the default selection of a combobox using formula?
Solved! Go to Solution.
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.
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'; ", " ) )
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
What am i forget ?
I respond to myself, need to use
RenameColumns(Split(dpd_recherche_etude.Selected.'Région concernée'; ",");"Result";"Value")
Keep up to date with current events and community announcements in the Power Apps community.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Check out the latest Community Blog from the community!