Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a simple "out of the box" approval workflow attached to a sharepoint calendar that kicks off when a user creates a new calendar item. I want the calender to only show items that have been approved via the workflow. Therefore, I created a lookup field on the calender that pulls the "Outcome" field from the workflow task list. I thought I could easily filter on the "Outcome" field by "begins with Approved" but I get the following error message:

The filter type you selected cannot be used with this type of column.

Any suggestions? Thanks!

share|improve this question

1 Answer 1

up vote 0 down vote accepted

From SharePoint error message:

The filter type you selected cannot be used with this type of column. You can apply the 'begins with' operator only to columns that have the type Single line of text, Multiple lines of text (without rich HTML), or Choice. Specify a different operator for the filter or change the column type. You can then attempt to create the filter again.

So you can:

  1. Change your column to Single line of text
  2. Or simply use Equal to operator as it does work with Lookup columns.
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.