Answered

Count SharePoint list rows with filter array multiple criteria

(0) Share

Report

Posted on by PowerApps999

Hello all,

I have a SharePoint list which contains three columns (Category, Activity & Tool). I am trying to create a flow to get an output of just the number of rows that matches each column criteria.

I tried using a filter array with the expression:

@And(equals(item()?['Title'], 'Communication'), equals(item()?['Activity'], 'With cargo'), equals(item()?['Tool'], 'email'))

[in the above expression Column and Condition]

And then Compose:

length(body('Filter_array')?['Value'])

But I am getting an error at Compose action and I am not even sure this is the right way. Can anyone assist me to fix this so that I only get the number of counts from the SharePoint list with filter criteria for each column?

PS: I achieved this in PowerApps using the below expression:

If(

CountIf(Categories, Category = "Communication" && Activity = "With cargo" && Tool = "email") = 0,

Blank(),

CountIf(Categories, Category = "Communication" && Activity = "With cargo" && Tool = "email")

)

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @PowerApps999

Pls try this in compose action:

length(body('Filter_array'))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
PowerApps999 62 on at

Like (0)

Report
Copy link

Link copied!

Thanks @ManishSolanki
Your expression works!
Right now I am trying to bring this count number (integer) to an Update a row action as you can see below:

Since the output of compose is an integer, an error occurs while running the flow (see below). It seems in the 'Update a row- Provide the item properties', it should be an array and not an integer
I tried the expression : createArray(length(body('Filter_array'))) ; but then the row in excel now is [1].
How can I 'Update the row' so that the number only is updated without the square bracket?

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @PowerApps999

There is no need for 'Apply to each' action or loop. The output of compose action is simply an integer but not an array. You can erase or remove the column value 'Provide item properties' from 'Update a row' action & drag out 'Update a row' action out of the loop. Delete "apply to each' action.

Just type the below expression in the textbox for updating the column value:

{
"email":@{outputs('Compose')}
}

Just copy & paste the above lines in the input column in "Update a row" action. Save & retest the flow.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No