Live training: next batches coming soon. Join the waitlist:Waitlists open:Developer Training →Developer →Copilot Studio Training →Copilot Studio →

Power Apps Concat Combo Box SelectedItems Into Text (+ a Custom Value)

People on our help desk pick two or three apps in a combo box, then type one more that isn’t on the list. SharePoint needed all of it in one readable line.

In this tutorial, we’ll use Power Apps Concat with combo box SelectedItems to turn the picks into text, add the typed value without stray commas, and save the result to a SharePoint list.

Quick answer: SelectedItems is a table, so wrap it in Concat to get one string. Concat(cbCcApps.SelectedItems, Value, ", ") returned “Microsoft Teams, Excel” in our test. To add a custom value safely, join it with an If that only adds the comma when both sides have text:

With(
    {
        picked: Concat(cbCcApps.SelectedItems, Value, ", "),
        other: Trim(txtCcOther.Text)
    },
    picked & If(!IsBlank(picked) && !IsBlank(other), ", ") & other
)

What You Need Before You Start

  • A Power Apps license that lets you build canvas apps, and edit rights on a SharePoint site (ours is /sites/SPGuides).
  • A canvas app with modern controls turned on. We used our responsive app, SPGuides Responsive Demo.
  • A SharePoint list with a multi-select Choice column. We’ll build ours, IT Help Requests, in Step 1.

Never built an app on a list? Our guide to create a canvas app from a SharePoint list covers the app side from zero, so you can come back here for the combo box part.

A few terms we’ll use: a data source is the connection that lets the app read a list, a record is one row, and a table is a set of rows. That last one matters, because SelectedItems is a table.

Step 1: Create the IT Help Requests List

On your SharePoint site, select New > List, pick Blank list, name it IT Help Requests and select Create. Then add these columns with Add column:

ColumnTypeSettings we used
TitleSingle line of text (built in)Filled by the app, e.g. Apps request 11/14/2026
CategoryChoiceHardware, Software, Access, Network
AppsChoiceMicrosoft Teams, Outlook, Excel, SharePoint, Power BI; multiple selections on; Can add values manually on
AppsSummaryMultiple lines of textPlain text; holds the joined string

A Choice column stores values from a fixed list. When you create Apps, open More options in the column panel, turn on multiple selections, and turn on Can add values manually. That second setting lets an item hold a value that isn’t one of the choices, which SharePoint’s classic settings call a fill-in choice.

We keep two copies on purpose. Apps holds each app as its own value, so you can filter and group on it. AppsSummary holds one sentence, which is easy to show in an email or a report.

Step 2: Add the List and a Header and Footer Screen

Open the app in Power Apps Studio (the editor at make.powerapps.com). On the left rail, select Data > Add data, search for SharePoint and pick the SharePoint connector.

Pick your site under Recent sites (or paste its URL and select Connect). In Choose a list, select the check box for IT Help Requests and select Connect. A banner confirms the data source was added.

Next, select New screen on the command bar and pick Header and footer. The screen comes with a header, a main section and a footer, each one a container that lines up its controls so the screen reflows on a phone (see containers in Power Apps).

In the main section we built roomy cards: one row with an Apps card and an Other app card, a Results card under it, and a row with two buttons, Save to SharePoint and Clear. We named the screen scrConcatCombo in the Tree view and turned the footer off.

Step 3: Add the Combo Box and the Custom Value Box

Select the Apps card, open Insert, search for combo box and pick the modern Combobox. Rename it cbCcApps in the Tree view so the formulas read clearly.

With cbCcApps selected, the box to the left of fx on the formula bar is the property dropdown. Pick Items there and type:

Choices([@'IT Help Requests'].Apps)

The Power Apps Choices function returns the Apps options as a one-column table named Value. Set ItemDisplayText to ThisItem.Value so each option shows its text.

In the properties pane on the right, check that Select multiple is On. Ours also showed Allow searching On and Default selected items None.

Modern combo box Items set to Choices of the IT Help Requests Apps column with Select multiple on

Now select the Other app card, insert a Text input, rename it txtCcOther and set its placeholder to “Type an app, e.g. Adobe Acrobat”. Our modern combo box control guide covers the rest of the combo box settings.

Step 4: Turn SelectedItems Into Text With Concat

SelectedItems is a table of every record the user picked, so a label can’t show it directly. Concat walks through that table and joins one value per row into a single string. Add a Text control to the Results card and set its Text property to:

Concat(cbCcApps.SelectedItems, Value, ", ")

Value is the column to read from each picked record, and “, ” is the separator. Concat puts the separator only between rows, never after the last one. With Microsoft Teams and Excel picked, the label showed “Microsoft Teams, Excel”.

The formula argument can be any text, not just a column. This version labels each app and uses a pipe between them:

Concat(cbCcApps.SelectedItems, "App: " & Value, " | ")

It returned “App: Microsoft Teams | App: Excel”. To count the picks, use CountRows on the same table, which gave 2:

CountRows(cbCcApps.SelectedItems)

For other ways to read the picks (Selected, First, a gallery), see how to get modern combo box selected values. To join plain strings without a table, read concatenate text strings in Power Apps.

Step 5: Add the Custom Value Without Stray Commas

The obvious move is to glue the text input on with & and a comma. Here’s that naive version:

Concat(cbCcApps.SelectedItems, Value, ", ") & ", " & txtCcOther.Text

It works when both boxes have something. With Microsoft Teams and Excel picked and Adobe Acrobat typed, it gave “Microsoft Teams, Excel, Adobe Acrobat”. The trouble shows up when one side is empty:

  • Other box empty: “Microsoft Teams, Excel,” with a trailing comma.
  • Nothing picked, Adobe Acrobat typed: “, Adobe Acrobat” with a leading comma.

The fix is to add the comma only when both parts have text. With names the two parts first, which keeps the formula readable:

With(
    {
        picked: Concat(cbCcApps.SelectedItems, Value, ", "),
        other: Trim(txtCcOther.Text)
    },
    picked & If(!IsBlank(picked) && !IsBlank(other), ", ") & other
)
Text property of the result label set to the With formula joining picked apps and the custom value

picked is the Concat result, and other is the typed text after Trim removes extra spaces. The If returns “, ” only when neither is blank (the Power Apps IsBlank function explains how blank is judged); otherwise it returns nothing.

Select Play at the top right (or hold Alt and click a control in the editor) to run the screen. With Microsoft Teams and Excel picked and Adobe Acrobat typed, result 3 reads “Microsoft Teams, Excel, Adobe Acrobat”:

Preview with Microsoft Teams and Excel picked, Adobe Acrobat typed and results 1 to 4 shown

Now the case that breaks the naive formula. Same screen, nothing picked, Adobe Acrobat typed: the naive line shows “, Adobe Acrobat”, while the With formula shows plain “Adobe Acrobat”.

Preview with nothing picked showing the naive leading comma next to the safe With result

Step 6: Save the Text and the Choices to SharePoint

We save both copies in one Power Apps Patch function call. Select the Save to SharePoint button, pick OnSelect and type:

Set(varCcText, With(
        {
            picked: Concat(cbCcApps.SelectedItems, Value, ", "),
            other: Trim(txtCcOther.Text)
        },
        picked & If(!IsBlank(picked) && !IsBlank(other), ", ") & other
    ));
Set(varCcSaved, Patch(
    'IT Help Requests',
    Defaults('IT Help Requests'),
    {
        Title: "Apps request " & Text(Today(), "mm/dd/yyyy"),
        Category: {Value: "Software"},
        AppsSummary: varCcText,
        Apps: ForAll(
            Filter(Split(varCcText, ", "), !IsBlank(Value)),
            {Value: ThisRecord.Value}
        )
    }
));
Notify("Saved item " & varCcSaved.ID & ": " & varCcSaved.AppsSummary, NotificationType.Success)
Save button OnSelect with Patch writing AppsSummary and a ForAll over Split into the Apps column

Here’s what each part does:

  • Set(varCcText, …) stores the joined string from Step 5 in a variable so we can reuse it.
  • Patch(…, Defaults(…), {…}) creates a new item. AppsSummary gets the text as is.
  • Split(varCcText, “, “) breaks the string back into a one-column table named Value (see the Power Apps Split function). Filter drops any blank piece.
  • ForAll turns each piece into a {Value: ...} record, so Apps receives a table with one record per app. Our Power Apps ForAll function post shows more uses.
  • Notify shows a green banner with the new item’s ID and summary (Power Apps Notify function).

We picked Microsoft Teams and Excel, typed Adobe Acrobat and clicked Save. The banner read “Saved item 1: Microsoft Teams, Excel, Adobe Acrobat”:

Green success banner reading Saved item 1 with Microsoft Teams, Excel and Adobe Acrobat

In SharePoint, item 1 has three separate Apps values: Microsoft Teams, Excel and Adobe Acrobat. Adobe Acrobat isn’t one of the column’s choices, so it went in as a fill-in value. AppsSummary holds the same three apps as one line, and Category reads Software.

A second save with only Adobe Acrobat typed created item 2, with Apps = Adobe Acrobat and AppsSummary = “Adobe Acrobat”:

IT Help Requests list showing the Apps and AppsSummary columns for items 1 and 2

Note: the earlier version of this post put the whole joined string into a single choice record, {Value: "a,b,c"}. That isn’t what we used here, and we didn’t test it. One record per value is the shape we tested, and it keeps each app filterable in the list.

The Clear button runs Reset(cbCcApps); Reset(txtCcOther) to empty both boxes after a save. More on that in our post on how to reset a Power Apps combo box.

Cheat Sheet: Combo Box Formulas We Tested

Same screen, same Apps column. These are the exact results from Preview:

FormulaPicks + typed valueResult
Concat(cbCcApps.SelectedItems, Value, ", ")Microsoft Teams, ExcelMicrosoft Teams, Excel
Concat(cbCcApps.SelectedItems, "App: " & Value, " | ")Microsoft Teams, ExcelApp: Microsoft Teams | App: Excel
CountRows(cbCcApps.SelectedItems)Microsoft Teams, Excel2
Naive & ", " &Microsoft Teams, Excel + (empty)Microsoft Teams, Excel, (trailing comma)
Naive & ", " &(none) + Adobe Acrobat, Adobe Acrobat (leading comma)
With formulaMicrosoft Teams, Excel + Adobe AcrobatMicrosoft Teams, Excel, Adobe Acrobat
With formula(none) + Adobe AcrobatAdobe Acrobat
Concat(...)Power BI, then OutlookPower BI, Outlook

Why Is the Concat Order Different From the Combo Box?

We picked Power BI first and Outlook second. Concat returned “Power BI, Outlook”, in the order we clicked, while the combo box itself displayed “Outlook, Power BI”, in list order.

So the saved summary follows the user’s click order, not the choice order. That’s fine for a readable note, but keep it in mind if a report or a flow expects the apps in list order.

Does the Modern Combo Box Have SearchText?

Yes. Microsoft’s reference lists SearchText as an output property of the modern combo box: the text the user is typing in the search box. It also says the search text clears when the user selects an item, and Reset clears both the selection and the search text.

The old version of this post read SearchText from a classic combo box inside a form card and used it as the custom value. Because modern search text clears on a pick, we use a separate text input for the custom value. It stays put while people pick apps, and it’s clear to users where to type.

Important: AllowExternalSelectedItems on the modern combo box doesn’t let users type a brand-new item either. The reference says it keeps earlier or default records selected, not free text.

Common Mistakes to Avoid

  • Putting SelectedItems straight into a Text property. It’s a table. Wrap it in Concat.
  • Using Selected on a multi-select box. With Select multiple on, Selected returns only the first pick. Use SelectedItems.
  • Gluing the custom value with & “, ” &. You get a trailing comma when the box is empty and a leading one when nothing is picked. Use the With formula.
  • Splitting on a different separator than you joined with. We joined with “, ” and split on “, “. An app name that itself contains a comma and space would split in two; pick another separator if that can happen.
  • Testing a count on an empty box. After a Reset, our CountRows label showed blank, not 0. Don’t compare it to 0 before you’ve checked it in Preview (the Power Apps CountRows function post covers counts).
  • Forgetting the Apps column settings. Our column had multiple selections and Can add values manually turned on, and that’s the setup our save was tested on.

Next Steps

Once the summary saves, use the category to show only the fields that matter, as in our show and hide fields by dropdown build on the same IT Help Requests list. For a form where the second choice depends on the first, follow the cascading dropdown in Power Apps tutorial.

You’ll find more combo box builds in our Power Apps tutorials.

We also wrote these if you’re working with multi-value fields:

Concat does a lot more than combo box picks. In the Power Apps Concat function guide, I turn collections and SharePoint columns into strings, put each item on its own line with Char(10) and compare Concat with Concatenate.

Frequently Asked Questions

How do I convert combo box SelectedItems to text in Power Apps?

Use Concat on the SelectedItems table with a column and a separator, for example Concat(cbCcApps.SelectedItems, Value, “, “). For a SharePoint Choice column the column is Value; for a list of records, use the column you show, such as Title.

How do I add a custom value to the combo box selections?

Add a text input next to the combo box and join both parts with With: picked & If(!IsBlank(picked) && !IsBlank(other), “, “) & other. The If adds the comma only when both sides have text, so you never get a leading or trailing comma.

Why does my Concat result end with a comma?

Concat itself only puts the separator between rows. A trailing comma usually comes from adding “, ” yourself with & when the other part is empty. The Concat and Concatenate reference shows the separator argument.

How do I save combo box values to a SharePoint multi-select choice column?

Patch the column with a table of records, one {Value: …} per app. We used ForAll(Filter(Split(varCcText, “, “), !IsBlank(Value)), {Value: ThisRecord.Value}), and with Can add values manually on, the typed app was saved as a fill-in value.

Does the modern combo box have a SearchText property?

Yes, as an output property. Microsoft notes that the search text clears when an item is selected and that Reset clears it too; see the Combo box modern control reference.