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
Solved! Go to 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.
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.
Thanks @tavila for replying, the array filter was the perfect way of getting the calculated column values.