cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SQEA
Level: Power Up

Change Status to Overdue in List if past Due Date EXCEPT where item Status is Closed

I have created a flow which will change the Staus in my action list to Overdue when the Due Date is past using apply to each but it also changes the status of those items which are already closed. Can anyone help with the command to exclude those with the status of Closed. 

 

FLOW.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Change Status to Overdue in List if past Due Date EXCEPT where item Status is Closed

Hi @SQEA , in the advanced options of the Get items you could initially filter out those those that are already closed by adding Status ne 'Closed' to the Filter query.

Rob
Los Gallardos

2 REPLIES 2
Super User
Super User

Re: Change Status to Overdue in List if past Due Date EXCEPT where item Status is Closed

Hi @SQEA , in the advanced options of the Get items you could initially filter out those those that are already closed by adding Status ne 'Closed' to the Filter query.

Rob
Los Gallardos

SQEA
Level: Power Up

Re: Change Status to Overdue in List if past Due Date EXCEPT where item Status is Closed

@RobElliottthank you for your help! 

>