cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
Super User III
Super User III

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

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

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

View solution in original post

Highlighted
New Member

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

@RobElliottthank you for your help! 

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,133)