cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Nintex O365 - Query list using a calculated column as a filter?

We know it's not an option to filter query list results with a calculated column.  In my case, I have:

A list with a choice column containing Status

A Date column containing "the date an item was moved into In Progress status"

A Date column (calculated) containing "Due Date"

A Date column containing "the date an item was moved into Completed status"

A number column (calculated)  containing "SLA days +/-"

A Yes/No column (calculated)  containng "SLA met?"

A workflow runs when an item is moved into "In Progress" and populates the date an item was moved into In Progress.

A workflow runs when an item is moved into "Completed" and populates the date an item was moved into Completed.

A calculation in "SLA days +/-" subtracts the date item was moved into Completed FROM the date item was moved into in progress and gets the difference, then subtracts 14 (the SLA is 14 days).

A calculation in "SLA met?" displays a Yes if the value is less than 0 and No if it's 0 or greater.

I'm trying to query the list to collect all the items where SLA was met and it's unavailable in the Query action.  I feel like I was able to do this easily on prem.

Any ideas?

Labels: (1)
0 Kudos
Reply