Others

How to Count Selected Values in a SharePoint Multi-Select Choice Column

Elise Williams Oct 19, 2026 868 views

Question details

The user needs a method to count specific selected values from a multi-select Choice column in a SharePoint list.

How to Count Selected Values in a SharePoint Multi-Select Choice Column

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Attempting to calculate or count matching text values from a SharePoint column that allows multiple selections.
Observed behavior: SharePoint calculated columns do not support multi-selection Choice columns as source fields, and standard Excel formulas cannot be directly applied to this configuration.

Before you start

Ensure you have the necessary permissions to edit the SharePoint list and verify that your Microsoft 365 account has an active Power Automate license to create custom flows.

Solution 1Recommended

Use Power Automate to Count Selections

Create a Power Automate flow to extract, filter, and count the specific items selected in your multi-select choice column.

Since multi-select Choice columns return data as an array rather than a simple string, native SharePoint calculated columns cannot process them. Power Automate solves this by manipulating the array directly.

Map the selected values

In your Power Automate flow, use the Select action and utilize the item() function to map the selected values from your SharePoint multi-select column.

Filter the array for specific values

Add a Filter array action to single out the names or choices you want to count. Use conditions such as @or(contains(item(), 'Name1'), contains(item(), 'Name2')) based on your target text.

Calculate the count of matching items

Add a Compose action and use the expression length(body('Filter_array')) to return the final count of matching selections from the filtered array.

Automation Complete: The output of the Compose action will now successfully yield the number of matching selections, which can be updated back to your SharePoint list automatically.

Solution 2

Switch to a Single-Selection Choice Column

If Power Automate is unavailable in your environment, modifying your list structure to use single-selection fields allows you to use standard calculated columns.

Free Microsoft Office alternative

Enhance Your Daily Workflow with WPS Office

While SharePoint handles complex list workflows, you need a powerful, reliable suite for your everyday documents, spreadsheets, and presentations. WPS Office provides a free, lightweight, and highly compatible alternative to heavy Office installations, letting you open, edit, and collaborate on Excel, Word, and PowerPoint files without a subscription.

100% compatible with Microsoft Office formats including XLSX, DOCX, and PPTXFree and lightweight alternative requiring less system resourcesFamiliar tabbed user interface for a seamless transitionBuilt-in PDF reader, editor, and format conversion tools

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my multi-select column appear in the SharePoint calculated column formula list?

SharePoint intentionally restricts multi-select Choice columns and Person/Group columns from being used as source fields in Calculated Columns because they store data as complex arrays rather than simple text.

Can I use standard Excel formulas directly in SharePoint to count these selections?

No, standard Excel text-matching formulas cannot process array values directly within a SharePoint list's calculated column. You must either use Power Automate or switch to single-select fields.

What if my organization doesn't have Power Automate licenses?

If Power Automate is unavailable, the best alternative is to restructure your SharePoint list. You can utilize single-select Choice columns or create separate individual fields, which are natively supported by SharePoint Calculated Columns.

Office Quick Solutions