PowerApps Form Control: multi-selections combobox not working

[tagustin2020]

Hello,

I'm working on a PowerApp where a requirement is the ability to select multiple tracks in the form control. Below are the column settings. 

Here is a snapshot of the form control. The Default property for the data card is ThisItem.Track. The Update property is cbTrack.Selected. I tried setting SelectMultiple on the combobox control to true and changing the Update property of the data card to cbTrack.SelectedItems, but that isn't working whether I have "Drop-Down Menu" or "Checkboxes (allow multiple selections)" selected in the SharePoint list column settings. The DefaultSelectedItems formula for the combobox is Parent.Default. If someone could help me figure out what I am doing wrong, I would appreciate it. Thank you! Teresa

[WarrenBelz]

Hi @tagustin2020 ,

Firstly, use the Checkboxes option in SharePoint and "Allow Multiple Selections" in Power Apps.

The Data Card Default is correct with ThisItem.Track and it should have a DataField of "Track" and an Update (as present)  of cbTrack.SelectedItems

The Combo Box Items should be Choices([@SPListName].Track) and DefaultSelectedItems ThisItem.Track or Parent.Default

Can you please check all of this first before I look at doing it "the long way".

[tagustin2020]

Thank you for the prompt reply Warren. It is always nice to hear from you 🙂 I made the changes you suggested, but PowerApps isn't falling in line yet so here are some more screenshots. 

I changed the column setting.

Here is a better snapshot of the data card settings. As you can see, I'm getting errors.

Here is a snapshot of the combobox values. the DefaultSelectedItems is Parent.Default. I tried ThisItem.Track as well, but this didn't resolve the errors.

My gallery Items formula also broke at the Track part of the formula. PowerApps doesn't like Track.Value=varTab anymore. This formula is working with a single selection.

SortByColumns(
    Filter(
        'Term Decoder',
        (StartsWith(
            'OCF Acronym',
            txtSearchBox.Text
        ) || StartsWith(
            'OCF Term',
            txtSearchBox.Text
        ) || StartsWith(
            'EBS Acronym',
            txtSearchBox.Text
        ) || StartsWith(
            'EBS Term',
            txtSearchBox.Text
        )) && ((Coalesce(
            varTab,
            "All Tracks"
        ) = "All Tracks") || Track.Value = varTab)
    ),
    "EBSAcronym",
    If(
        SortDescending,
        SortOrder.Descending,
        SortOrder.Ascending
    ))

Let me know if I left anything out. Thank you, Teresa

[WarrenBelz · Accepted solution]

Hi @tagustin2020 ,

Firstly, I have seen other examples of controls breaking/corrupting when the underlying field type is changed, so delete that data card in power apps add a new one with the multiple selection enabled in SharePoint - Power Apps should take care of the settings. For your formula you will need something like this

varTab = "All Tracks" || varTab in Track.Value

with a resulting Delegation issue - so the best you can do is this

With(
   {
      wData:
      SortByColumns(
         Filter(
            'Term Decoder',
            StartsWith(
               'OCF Acronym',
               txtSearchBox.Text
            ) || 
            StartsWith(
               'OCF Term',
               txtSearchBox.Text
            ) || 
            StartsWith(
               'EBS Acronym',
               txtSearchBox.Text
            ) || 
            StartsWith(
               'EBS Term',
               txtSearchBox.Text
            )
         ),
         "EBSAcronym",
         If(
            SortDescending,
            SortOrder.Descending,
            SortOrder.Ascending
         )
      )
   },
   Filter(
      wData,
      varTab = "All Tracks" || varTab in Track.Value
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[tagustin2020]

@WarrenBelz 

Thank you, Warren! With your help I'm most of the way there. The form is working as intended now. Just need a little help on the filter formula.

Form Control working - Check!

Gallery Text Label to display selections (see blue highlighted section). The label formula is:

Left(Concat(ThisItem.Category.Value, Value & ", "), Len(Concat(ThisItem.Category.Value, Value & ", ")) - 2)

Here is where I could use some help. When I click on the Finance button, the APC acronym experiment isn't displayed. When I click on the General button, the APC acronym does appear in the results. General was the last of the two selections made in the combobox control. What do I need to do to adjust the filter formula you provided earlier?

[WarrenBelz]

Hi @tagustin2020 ,

Firstly, you only need this

Concat(
   ThisItem.Category.Value, 
   Value, 
   ", "
)

but I am a little lost as to how that related to the filter code as it is simply a calculated label.

[tagustin2020]

@WarrenBelz 

Hello Warren,

Turns out my gallery issue had a simple solution. I couldn't get my original choice column called "Track" to cooperate so I created a new column called "Category" for the multi-select choice column. My Gallery Items formula was still set to the column named "Track". Once I changed it to "Category" everything worked fine. Thank you again for your help. Have a good day!

Teresa