Friday, January 11, 2013

How to filter a SharePoint list by a workflow status

When you create a workflow on a list or library, SharePoint adds a new column to the list showing the workflow's status. You can add this column to a view and you can sort by it. However, when you try to filter by this column, to show only the Status = Canceled rows for example, you will get an emty list.

The reason is that the workflow's status is really a numeric value. So for the Canceled status you need to enter 15 and Completed = 5. I found this solution after I added the column to the view and exported the list to Excel. There I saw the numeric values.

No comments:

Post a Comment

Enter your comment here