Schedule flow to auto close requested items when all associated catalog tasks are closed

[Community Alums]

I'm trying to create a flow to run once a day to check if there are any requested items in active state even all the associated catalog tasks for that item are closed. But my flow is checking first task and if its closed, its closing the requested item though there are open tasks left for the same requested item. 

[Sandeep Rajput]

You need to use two look up records, one to get total number of catalog task of the request and other one to get closed tasks. Compare the count of both of these lookups using an if block and close the request if both of these counts are equal.

[Community Alums]

Hi @Sandeep Rajput I'm not sure how to achieve it, could you please share more details.

[Community Alums]

@SAI VENKATESH - Would you be able help here?