Power Platform Community Forum Thread Details

I have a sharepoint list with a column called ClassesTaught populated by a multiselect combo box. The datasource for the combo box is the choice column (ClassesTaught). The resulting sharepoint list is shown in Figure 1. I need to flatten the table so that a teacher (CreatedBy) can remove one of the ClassesTaught if necessary. Figure 3 shows my gallery with its items property set to the sharepoint list. The data is in and figure 4 shows the labels text property. I get the subject back because it is a single line of text. The classes taught is a complex column of type choice and i cant get the classes to display as individual line items. Using a flow is not a practical solution as I dont have access to a service account and when my password changes it will break.

should present the data.

Categories:

Building Power Apps

Hi there!! , to flatten a SharePoint multi-select choice column like ClassesTaught in Power Apps and allow item-level removal, use Ungroup() and Concat() functions to extract individual values into a gallery. This avoids Power Automate and works entirely within Power Apps.

Solution:

1. Flatten the Multi-Select Choice Column
Use Ungroup() to extract individual values from the ClassesTaught column:

Ungroup(
    AddColumns(
        Filter(TeachersProfiles, CreatedBy.Email = User().Email),
        "FlattenedClasses", ClassesTaught
    ),
    "FlattenedClasses"
)

This creates a flat list of class values from the multi-select column.

2. Display in a Gallery
Set the Items property of your gallery to the formula above. Then use:

ThisItem.Value

…in the label to show each class name.

3. Enable Removal of Individual Classes
Add a trash icon or button next to each item in the gallery. Set its OnSelect to:

Patch(
    TeachersProfiles,
    LookUp(TeachersProfiles, CreatedBy.Email = User().Email),
    {
        ClassesTaught: Remove(ClassesTaught, ThisItem)
    }
)

This removes the selected class from the ClassesTaught array for that teacher.

Note: Remove() works only if ClassesTaught is a collection of values. If it’s a complex object (e.g., {Value: "8E1"}), you may need to match by Value.

Tips

• Use Choices(TeachersProfiles.ClassesTaught) to get the full list of available class options.
• If ClassesTaught is stored as {Value: "ClassName"}, use ThisItem.Value to access the name.
• Always test with a user who has edit permissions on the SharePoint list.

Helpful Resources

How to display the item of choice column in the gallery of power apps?

SharePoint List with a Choice column that is set to “allow multiple selections”

If this helped or could help others in the community, feel free to give it a like or a kudo — it helps surface useful answers for everyone!