SharePoint is returning a "Coercion warning: user or group does not have a valid e-mail address." when I attempt to target a SharePoint Group with users inside it via a SharePoint Designer 2010 Workflow.
Here are the steps I have performed:
- Setup a "Person or Group" column with the following settings:
- Require that this column contains information: Yes
- Enforce unique values: No
- Allow multiple selections: No
- Allow selection of: People and Groups
- Choose from: All Users
- Show field: Name (with Presence)
- Created a SharePoint Group containing the following settings and with members who all have proper email addresses that are each in the format: email@example.com
- Who can view the membership of the group? Everyone
- Who can edit the membership of the group? Group Owner
- Allow requests to join/leave this group? No
- Auto-accept requests? No
- Send membership requests to the following e-mail address: (empty)
- Access given to the entire site and the list: READ
I've attempted to target the column in designer by "Email Addresses, Semicolon Delimited" and "As String". This falls in line with what Microsoft has listed in their instructions but it just isn't working.
Important The columns in which you store addresses for workflow e-mail messages can be either Single line of text, Multiple lines of text, or Person or Group type columns. If you use a Person or Group column, only one entry can be made in each field that the workflow will reference for e-mail addresses. When creating the column, be sure to select No under Allow multiple selections. If you want to use this type of column to specify multiple recipients, you can create a SharePoint group that includes the people that you want the workflow to address the e-mail to, and then specify the group in the field. When creating the column, be sure to select People and Groups under Allow selection of. Find a link to more information about creating lists and adding columns in the See Also section.
Note When creating SharePoint groups, make sure that each group has at least Read permissions for the site, and that in the Group Settings area of the New Group Page, under Who can view the membership of the group, Everyone is selected.
However, I am getting the aforementioned error and the variable that gets returned is always empty if I attempt to log this to workflow history and see what is going on. What is really frustrating here is if I add single users instead of using a SharePoint group it works fine. Also, in a separate List on the same site with the same permissions/settings/etc. it works fine.
I did see a KB article (http://support.microsoft.com/kb/2679159) that details the problem but we are not using an Association List like they describe. I did attempt to switch to "Login Names, Semicolon Delimited" but that did not work either. The workflow actually locks up when I do that. Nothing strange about our login names either as they are the typical DOMAIN\username setup.
Really at a loss here and the company really needs this workflow working. Any help is appreciated. Thanks.