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 XXX@domain.com 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? – Ganesh Sanap Sep 12 '19 at 8:39
  • yes, added to the second list "DataCollection" – Manshoor PH Sep 12 '19 at 8:44
  • This is SharePoint designer workflow 2013, right? Also, Can you post the error you are getting after executing the workflow? – Ganesh Sanap Sep 12 '19 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 – Manshoor PH Sep 12 '19 at 9:13
  • i couldn't see any option to attach the screenshots – Manshoor PH Sep 12 '19 at 9:15

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..........!!! – Manshoor PH Sep 12 '19 at 11:00
  • Welcome. Please Upvote ( ^ ) and accept it is an answer if it helped you. – Ganesh Sanap Sep 12 '19 at 11:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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