ComboBox DefaultSelectedItems

[droper]

Hi All,

So I'm having an issue with ComboBox and DefaultSelectedItems not actually being stored.

Similar to this post, but I am not using datacards so the workaround doesnt assist: https://powerusers.microsoft.com/t5/General-Discussion/Powerapps-saving-combo-box-default-value-no-u...

I have a multiple selection Combobox with DefaultSelectedItems pointing to a Datatable field (which is inturn a lookup field in SP, so contains Id & Value). The idea is that the user needs to confirm a previous selection before submission, but they have the ability to modify it first if something has changed.

Now the default items set fine, it visually shows on the combobox, but if you try and actually see the data behind it, it knows there are items but the values are blank. I can even reselect an already selected item and it doubles up in the combobox, I assume because the defaultitem value isnt being stored it doesnt realise that newly selected value is already present.

To prove the point I created another DataTable which has Items=Combobox.SelectedItems so that I could see the stored contents live, and while it does return the right number of rows for the defaultselecteditems in the combobox, the values are blank. If however I select additional items in the combobox, the new values do appear, further backing up the point that the defaultselecteditems values are not actually being stored as a real selected item.

If anyone has any thoughts, it would be greatly apreciated, as this is essentially the last hurdle to having a full functioning app!

Thanks in advance.

[droper · Accepted solution]

So it looks like I've found a solution for anyone else that comes across this in future.

The issue was that the combobox defaultselecteditems needs ID and DisplayField, not Id (lowercase d) and Value as returned by the multiple selection field from sharepoint.

The workaround was to correct the column names in defaultselecteditems, which then stored the actual data.

EG:  DefaultSelectedItems = RenameColumns(DataTable.Selected.Items,"Id","ID","Value","DisplayField")

[gautmish]

Hi @droper,

 Need urgent help on setting default selected item of a combobox .

 I am storing the combobox selected item in to a text field of sharepoint with "," separated .

Textvalue = "Item1,Item2,Item3"

So when next time user will navigate to the form , he should be able to see Item1, Item2,Item3 selected .

and it should not allow user to select Item1 or Item2 or Item3 again .

Please suggest.

Thanks

Gautmish

[droper]

Hi,

First thing that springs to mind is that the defaultselecteditems property requires table values, not a single string of text as you have. So you would either need to wrap this in the table function or store it in a collection first with clearcollect and reference that.

Here is another thread to do with the basics of setting default values that might help explain it further:

https://powerusers.microsoft.com/t5/General-Discussion/How-To-set-the-selected-value-of-a-combo-box-...

[digitaldanlim26]

use ForAll function in DefaultSelectedItems property

ForAll(tableSource,Result)

[Anonymous]

I am having issues with DefaultSelectedItems.

If user do not make changes to Combobox DefaultSelectedItems than empty string is returned when submit form.

i.e.  

ComboBox1 DefaultSelectedItems=RenameColumns(Split("Ankit, Dinesh",", "), "Result", "Value")
ComboBox1's DataCard Update=Concat(ComboBox1.SelectedItems, FNspecified &"",", ")
Returns only following
", "

Expected was
"Ankit, Dinesh"

Please help !

[Syme]

I'm experiencing the same problem @Anonymous .

Any luck?

********* UPDATE **********

My situation was rather complicated, but my problem which @Anonymous so succinctly described was solved when I used ShowColumns() to include the display column AND the foreign key. I was simply missing the foreign key which was required by Update.

[tgh]

ForAll(Split(Parent.Default, ","), Result)

update (9/18) - don't violate first normal form by passing a comma-separated list into one column...

--> where the parent element is a datacard getting passed a value from a gallery (e.g., Gallery1.Selected.'Column Name'). Luckily this ForAll only has to loop through three elements thus mitigating the performance concerns. The formula Splits on a comma because the data stored in my dataverse table originally came from a multi-select combobox (i.e., the update property of the datacard for that combobox looked like this Concat(Sort(combobox1.SelectedItems.Value, Value),Value,"," )) that concatenated all the selections and put them together as one string separate by a comma (no space and the sort is a stylistic thing).