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!
