I have a list named as "Class" and title column with fields (SMS, BP, HVL, TA).

The second list "DataCollection" has a column from Class using lookup.

Now, I want to check the condition in designer workflow "if current item: Class equals SMS" Action >> Send Email to [email protected] End workflow

The system shows error when I I execute this workflow.

Somebody please help to find a solution.

  • Have you added your workflow on second list, DataCollection list? Sep 12, 2019 at 8:39
  • yes, added to the second list "DataCollection" Sep 12, 2019 at 8:44
  • This is SharePoint designer workflow 2013, right? Also, Can you post the error you are getting after executing the workflow? Sep 12, 2019 at 8:59
  • The workflow is executing smoothly but this condition is not applying due to lookup field value check. I mean, the workflow didn't check this if condition Sep 12, 2019 at 9:13
  • i couldn't see any option to attach the screenshots Sep 12, 2019 at 9:15

1 Answer 1


Follow Below Steps:

  1. At the Starting of your workflow, use Set Workflow Variable action and create on new variable of type string. Set it's value as a lookup column value. (See attached image below).
  2. Add IF condition, In Left side, Select the workflow variable we created.
  3. In Right side of equals, Type SMS.
  4. Inside IF condition, Use Send Email action.

enter image description here

Note: If your lookup column is set to allow multiple values then instead of equals operator, you can use contains operator.

  • Many thanks Brother. it worked well..........!!! Sep 12, 2019 at 11:00
  • Welcome. Please Upvote ( ^ ) and accept it is an answer if it helped you. Sep 12, 2019 at 11:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.