You’re offline. This is a read only version of the page.
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:
However no default selection is shown:
How do set the default selection of a combobox using formula?
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
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.
Share
Report
All responses (
Answers (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 ?
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.
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.
use ForAll function in DefaultSelectedItems property
ForAll(tableSource,Result)
Hi,
I'm also having same kind of issue.
In my scenario,
I have a combo box which will be filtered based on values we choose from a Dropdown
DropDown= A, B,C
when a user selects A,C then there will be only 1 value in the combo box,
But when they choose B there will be multiple options on Combobox they need to select.
What my issue is: When a user selects A,C from dropdown a textbox should be populated with Combobox value automatically, but when user selects B they should be able to select options from combobox values.
How can i set the properties.
texbox needs to be populated conditionally. like when they select A,C from dropdown then the textbox value should be the only value from combobox.
When they select B from the dropdown, they should be able to select 3 values from combobox and populate into the textbox.
textBox= Concat(combobox.SelectedItems,Result&",")
This is the formual i used on textbox.So what ever user selects on combobox will bepopulated into textbox
But textbox should be set to default combobox option when they select A,C from dropdown
I wasn't using a datacard with my combo box but I was able to work through the issue. Turns out that when I added the defaultselecteditems property, it decided to change what values it was returning back. I had to change the DisplayFields and SearchFields back to what I originally had on that combobox and everything worked perfectly. Thanks for the help though!
#1
WarrenBelz
262
Most Valuable Professional
#2
MS.Ragavendar
134
#3
stampcoin
123
