Answered

Extracting count of variable from column within Sharepoint table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello all,

I am trying to build a flow that extracts the count of various values from a SharePoint table and updates these values into a new row of an excel table.

The SharePoint table contains multiple columns. One column contains the status of the entry and has the value either 'Open' or 'Closed'

I successfully counted the total number of entries (or rows) in the SharePoint table using 'Get Items' and 'Compose' and deposited this value into my excel table.

I need to extract the number of entries in the Status column that have the value 'Open'. From this I can then derive the number of entries that are 'Closed'.

update excel flow.PNG filter array output.PNG

As you can see above my current method takes a long time to run.

Also, the filter array block correctly filters all of the 'Open' entries, but I need the number of these, and I can't figure out how to output this. FYI: After counting the number of entries myself in the output I get the expected number.

Does anybody have a solution?

Categories:

Building flows

All responses (2)

Answers (1)

Sort by

Verified answer

grantjenkins 11,063 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
If you've got your Filter array containing only items where the Status is Open, then you can just use a Compose or Variable with the following expression to count how many items are in your Filter array.

length(body('Filter_array'))

You can then get the number of item's that don't have a Status of Open (Closed) by subtracting the length of that output from the length of Get items.

sub(length(outputs('Get_items')?['body']), outputs('Compose_Open'))
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, this worked!