Combo Box DefaultSelectedItems from Collection values from SharePoint List

[NHammond37]

Hello,

I am looking to have a Multiple Selection Combo Box be preselected with some of the values available. I have a SharePoint List with some entries that a user can choose from the PowerApp and it loads that entries values in to Labels. They can then choose to edit some of these fields. When the user chooses to edit the field, that Combo Box appears and I would like it to populate with the values that the entry has. When the user chooses to edit that field, I have a formula that looks at the value and parses it out since it is a string. Then it looks at each value and looks it up in another SharePoint list that the Combo Box also ties into for the options available. I add these values to a Collection and have been trying to get the formula correct in the DefaultSelectedItems property as well have been messing around with the Default property.

Some of the formula I have been trying in the DefaultSelectedItems propert without any luck. LocUsed is the name of the Collection. Loc is the name of the column in the LocUsed Collection.

ForAll(LocUsed, {Loc: 'Location Table'.'Location ID'})

LookUp('Location Table', 'Location Table'.'Location ID' = LocUsed.Loc)

I have tried some variations of the above. I get it to say it has no errors but it never populates the value. I think I am missing how the Combo Box wants to read in from the table of what items to be preselected.

Feel free to ask me for additional details if needed.

Thank you!

[RandyHayes]

@NHammond37 

What is the Items property of your ComboBox?  

To have items selected, the DefaultItemsSelected records MUST match the signature (columns) of the Items property exactly.

[NHammond37]

Filter('Location Table'.'Concatenated Name', Not("DO NOT USE" in 'Concatenated Name'))

This is the Items property on the Combo Box. I had to filter it a little bit to get rid of locations that shouldn't be used. Are signature columns like the ID column on a SharePoint List or can you set columns you create as signature columns as well?

[RandyHayes · Accepted solution]

@NHammond37 

So then, your ComboBox items has only ONE column - 'Concatenated Name'.

Your DefaultSelectedItems needs to match that:

ForAll(LocUsed, {'Concatenated Name': Loc})

This assumes that Loc is the matching column in your LocUsed (collection, variable, etc)

If it is not, then replace with the appropriate one.

[NHammond37]

Thank you so much!!! It's working!! I've been trying to figure out what was wrong for awhile now.

[RandyHayes]

@NHammond37 

Always a good learning process to hash it out on your own, but if it starts to frustrate, come on over to the forum and post 🙂

[mariominiaci]

Just want to thank you for this clear answer AND the clear question posted originally. I have been trying to move the value from one multi-select combobox to another of a different format all day, and this cracked it. I'm now going to go read all about ForAll.

Cheers guys.