Counting the values within a SharePoint calculated column

[Rob_CTL]

Hi,

I have a SharePoint list that has a number of columns that are used to show the status of a report.  What I'd like to do is count a specific value that is entered into the column, this is usually "Yes", "No".   As mentioned I am only interested in a specific value with each column, for example the "Report Complete" column I only want to count the "No" values

I've done this in the past by using a ODATA filter on the "Get Items" control but this is where it gets tricky, these columns are calculated columns and the ODATA filter doesn't work on these column types.

I have been messing about with variables but I am not getting anywhere fast hence reaching out to the community to see if anyone can help.

Thanks in advance

Rob

[tavila · Accepted solution]

Hey Rob,

Thanks for your question.

I would suggest one of these two approaches documented here: https://powerusers.microsoft.com/t5/Building-Flows/Microsoft-Flow-SharePoint-list-calculated-column-...and here https://powerusers.microsoft.com/t5/Building-Power-Apps/SharePoint-List-Calculated-Columns/td-p/5000....

Thanks.

[Rob_CTL]

Thanks @tavila for replying, the array filter was the perfect way of getting the calculated column values.