Multiple Value Lookups in Sharepoint Designer Workflow

Requirement

----------------------------------------------------------------------------------------------

I had a requirement where Lookup column has multiple value selection turned on. There is a field in Master list with person & groups as datatype. I need to send email to each user for the selected value in multiple lookup column.

Issue

----------------------------------------------------------------------------------------------

Sharepoint designer workflow lookup returns single value for the joined criteria.

Resolution

---------------------------------------------------------------------------------------------

Solution is to write a Custom Activity that can be used in Sharepoint Designer workflow.

Activity can return comma seperated string of email addresses Or any other field based on user

input.