Power Automate – Community Question Explained – SharePoint List task updates

This video is based on Microsoft Power Automate Community question:

https://powerusers.microsoft.com/t5/Building-Flows/Count-Items-in-SharePoint-Online-List-Depeding-on-Variable/m-p/2024730#M223695

Expressions I used in this video are:

Total Pending
length(body(‘Filter_array_Pending’))

Total Completed
length(body(‘Filter_array_Completed’))

Total Tasks
add(outputs(‘Total_Completed’),outputs(‘Total_Pending’))

Completed
if(equals(outputs(‘Total_Pending’),0),’Completed’,’In Progress’)

IF Condition Expression
length(outputs(‘Get_items_List1’)?[‘body/value’])