Set ComboBox DefaultSelectedItems

[gautmish]

Hi Team,

 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

[TimRohr · Accepted solution]

I think you're going to have to use Split() to parse that string into a 1d table.

Once you have that, look at this thread for how you go about disallowing those items:

https://powerusers.microsoft.com/t5/Expressions-and-Formulas/Primary-Secondary-and-Tertiary-Drop-Dow...

[MihirY]

I got the table by using split function. I have done as below

UpdateContext({defaultSelectedItems: (Split(LookUp(MultiValueTransaction,ID=glbSelValue.ID,TransRelationValues),",").Result)});
Clear(colDefaultItems);
ForAll(defaultSelectedItems,Collect(colDefaultItems,Result))

I am getting the table then converting to collection. I have applied this to combo box which i am seeing the results. but the problem is those results were not selected in the combobox as shown in below pictures. 

Same value has been selecting twice but when I deselect the same value previous value (from code) is still there. 

How to fix this?