Counting Comma Separated Values in Sharepoint List

(0) Share

Report

Posted on by nomanahmed

Hi everyone...need some expert advice here 🙂

I have a scenario, where my SharePoint list has multi-select column.

I want to count all multi-selected values in that list including single selections against a specific item.

below example can explain it,

Type	Values
Item 1	Sub 1, Sub 2
Item 2	Sub 1
Item 1	Sub 3
Item 2	Sub 2

What I want is:

Item 1: Sub Items count: 3

Item 2: Sub Items count: 2

any help would be appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nomanahmed ,

I assume there is a collection:

ClearCollect( CollectionA, {Type:"Item1",Values:"Sub 1,Sub 2"}, {Type:"Item2",Values:"Sub 1"}, {Type:"Item1",Values:"Sub 3"}, {Type:"Item2",Values:"Sub 2"} );

You could try this formula:

AddColumns( GroupBy(Ungroup(AddColumns(CollectionA,"SplitValue",Split(Values,",")),"SplitValue"),"Type","ValueGroup"), "Sub Items Count", CountRows(ValueGroup) )

Best Regards,

Bof

Was this reply helpful? Yes No
nomanahmed 6 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the reply @v-bofeng-msft & the solution,

while I am still in learning phase, additional help needed 🙂

I am trying to figure out how to perform this... actually, I have a gallery showing the items and i need to show the count in a label under each of the gallery items. source of my gallery is the collection. how & where to add this code

both of the columns (Type & Values) are lookup columns.

AddColumns( GroupBy(Ungroup(AddColumns(CollectionA,"SplitValue",Split(Values,",")),"SplitValue"),"Type","ValueGroup"), "Sub Items Count", CountRows(ValueGroup) )

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nomanahmed ,

I've made a test for your reference:
1\My SP list:

2\

ShowColumns( AddColumns( GroupBy( Ungroup(AddColumns(Bof02033,"TheType",TypeColumn.Value),"Values"), "TheType","ValueGroup"), "Sub Items Count", CountRows(ValueGroup) ),"TheType","Sub Items Count")

Best Regards,
Bof

Was this reply helpful? Yes No
nomanahmed 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-bofeng-msft. :).

Was this reply helpful? Yes No