PowerAutomate Count If Greater then 0 (1 Viewer)

E9-Tech

New member
Local time
Today, 13:25
Joined
Apr 28, 2021
Messages
2
I need the correct formula to count the items from a Get items, I need to count those records where Days is greater than 0.
I have a variable TotCount with the he expression:
Code:
if(greater(item()?['Days'], 0), 0, 1)

The above code always returns 0, below are a few example of what I need:

Days
1
0
5
TotCount = 2


Days
1
22
3
7
12
TotCount =5

Days
1
0
3
7
12
TotCount =4
 

Users who are viewing this thread

Top Bottom