Filter SharePoint List or Library items based on Approval Workflow status

If you want to filter a SharePoint library/list based on the value of a column, you type in the text string that you want to filter on. But you can’t use the text such as “Approved”, “Canceled”, etc when you try to filter items in a list on an Approval Workflow column. Instead of using text value you have to use the integer value for the status.

Here are the integer values:

0 – Starting

1 – Failed on Start

2 – In Progress

3 – Error Occurred

4 – Canceled

5 – Completed

6 – Failed on Start (retrying)

7 – Error Occurred (retrying

15 – Canceled

16 – Approved

17 – Rejected

Advertisement