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:
| Column | Type | Settings we used |
|---|---|---|
| Title | Single line of text (built in) | Filled by the app, e.g. Apps request 11/14/2026 |
| Category | Choice | Hardware, Software, Access, Network |
| Apps | Choice | Microsoft Teams, Outlook, Excel, SharePoint, Power BI; multiple selections on; Can add values manually on |
| AppsSummary | Multiple lines of text | Plain 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.

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
)

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”:

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”.

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)

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”:

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”:

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:
| Formula | Picks + typed value | Result |
|---|---|---|
Concat(cbCcApps.SelectedItems, Value, ", ") | Microsoft Teams, Excel | Microsoft Teams, Excel |
Concat(cbCcApps.SelectedItems, "App: " & Value, " | ") | Microsoft Teams, Excel | App: Microsoft Teams | App: Excel |
CountRows(cbCcApps.SelectedItems) | Microsoft Teams, Excel | 2 |
Naive & ", " & | Microsoft Teams, Excel + (empty) | Microsoft Teams, Excel, (trailing comma) |
Naive & ", " & | (none) + Adobe Acrobat | , Adobe Acrobat (leading comma) |
| With formula | Microsoft Teams, Excel + Adobe Acrobat | Microsoft Teams, Excel, Adobe Acrobat |
| With formula | (none) + Adobe Acrobat | Adobe Acrobat |
Concat(...) | Power BI, then Outlook | Power 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.

Hey! I’m Bijay Kumar, founder of SPGuides.com and a Microsoft Business Applications MVP (Power Automate, Power Apps). I launched this site in 2020 because I truly enjoy working with SharePoint, Power Platform, and SharePoint Framework (SPFx), and wanted to share that passion through step-by-step tutorials, guides, and training videos. My mission is to help you learn these technologies so you can utilize SharePoint, enhance productivity, and potentially build business solutions along the way.