cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vsharma2
Helper III
Helper III

Over due Item form the column

Can someone please tell me the filter array expression to select overdue items from the columns?

 

Kind regards, 

 

V

2 REPLIES 2
Sundeep_Malik
Community Champion
Community Champion

Hey @vsharma2 

Can you show how your array looks like?

Hi @Sundeep_Malik ,

 

Here is my Array:

 

vsharma2_0-1663627215626.png

 

My expression : @and(lessOrEquals(item()?['DueDate'], addDays(utcNow(), 7, 'yyyy-MM-dd')),equals(item()?['TestStatus/Value'], 'NotStarted'))

I want to filter overdue item where it has to match the condition that other column should have the value.

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,774)