cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

count a specified Column in an SharePoint List?

Is there a way to count a specified Column in an SharePoint List? Thanks in advance

Labels: (1)
0 Kudos
Reply
4 Replies
Highlighted
Nintex Newbie

Re: count a specified Column in an SharePoint List?

Murat, could you be more specific?  Count it in what way?  Are you looking to sum all the values in a column?  Are you wanting to count all the rows where a column is empty, or not empty?  And are you doing this in a workflow or on a form?  What version of Nintex are you using?

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: count a specified Column in an SharePoint List?

Hi Brendan,

of course.

Let me explain. I have a SP Table like

ID | A | B | C | D

1 | cr | x | x | 1

2 | cr | x | x | 2

3 | x  | x | x | 2

4 | cr | x | x | 3

What i need is the amount of the column "A" (where the value is "cr") and put the value in columnd D.

In my example (4 Entries) there are 3 "cr".

The Nintex Workflow should calculate and put the value in D.

I am using 3.0.8.0 (WF 2013).

Hope it helps.

Greetings, Murat

0 Kudos
Reply
Highlighted
Not applicable

Re: count a specified Column in an SharePoint List?

Query list activity - filter where column A is = current item value of column A, store ID in collection variable.

Collection activity - on your collection variable, perform a "count"

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: count a specified Column in an SharePoint List?

This should be marked as the correct answer.

0 Kudos
Reply