i do hope you can help. Im very much an amatuer beginner when it comes to SharePoint Designer but am struggling with a list workflow issue.
Im trying to set up a workflow to send emails to the relevant people based upon the 'Request Status' set within the list. Im using 'IF' statements but need to sometimes base the conditions based upon a field value as well as a lookup on another list field.
See code below:
IF CurrentItem:Request Status equals (3) Submitted
and CurrentItem:SiteCode:Region equals Europe
Email Regional IT Approvers (Europe)
************************************
IF CurrentItem:Request Status equals (3) Submitted
and CurrentItem:SiteCode:Region equals South America
Email Regional IT Approvers (South America)
The first issue is with the SiteCode lookup. Site code is a drop down list relating to a master lookup list on the site. In this list are Codes for all global sites, plus the region they all fall in e.g. Europe, South America etc.
The next issue is with the Email side of things. For some reason, i can email an individual user, when the 'Email Person of Group' option is selected but when a Sharepoint group is selected, no users within that group are emailed.
Any help would be greatly appreciated as i need to get this issue resolved as a matter of urgency. Thanks guys
Luke
