Workaround: SharePoint Workflow and Task Assignment by Email Address
September 29, 2010
Posted by on
SharePoint Desinger Workflow with InfoPath not filling in the Assigned To field on a Task when you specify it by Email Address
What we have here seemed to be pretty simple: we have an InfoPath form where you filled in your name and email address, and then your manager’s name and email address (I know we could have done that automatically but that’s besides the point for this post). Then we have a SharePoint Designer workflow that first forcibly sends an email to the Manager’s Email using the “Send an Email” action, and it then uses “Assign a To-Do Item” i.e. creates a task to the manager, AGAIN BY THEIR EMAIL ADDRESS, not by a login name.
Well to complicate the matter just a little bit, we have 2 domains – one of which is a “One Way Trust”. Now that being said, you can add users from this second domain no problem either using the Add User people picker, or by going into a new task manually and using the people picker. So it is getting to the other domain fine (we have already run the stsadm command -o setproperty -pn peoplepicker-searchadforests).
What the problem was, though, is that when we fill out an InfoPath form, and for the manager’s name, use an email that resolves to an account on our “local” domain, it works just fine. However, as soon as you try to assign a to-do item, by email address, to a user in the One Way Trust domain, we end up with a blank Assigned To field in the task that was created for us.
We still don’t have a solution, but here’s the workaround:
We found a workaround. Here’s the steps that I took to get this “working” per se:
- Inside SharePoint
- Create a Person Field
- Create a new Column in the InfoPath Form Library.
- Make sure it is a Person or Group field.
- Make sure it selects from “All People”.
- For sake of our example, we’ll call it “Manager Assigned”
- Inside your SharePoint Designer Workflow
- Assign the email address into the Person Field
- Add the action “Set Field in Current Item”
- Click “field” and set it to the Column you created in step 1 (“Manager Assigned”)
- Click the “value” and in the “Select Users” dialog box double-click “Workflow Lookup”
- From the “Current Item” as a Source, choose the field in your InfoPath Form that represents your email address you want to use (“Manager Email”)
- Pause the workflow
- Add the action “Pause for Duration”
- Set it to 0 days, 0 hours, and 1 minutes
- Assign your Task to the Person Field
- Add the action “Assign a To-Do Item” (or “Collect Data from a User”)
- Set up your task’s name and description (and any custom fields for a Collect Data action)
- For the person that you want to assign it to, double-click “Workflow Lookup”
- From the “Current Item” as a Source, choose the custom field in your Form Library that represents the Person Field (“Manager Assigned”)
We also tried just pausing first and then setting the Task directly to the email address, but that didn’t work either. Something about it not being able to resolve the user name in a timely manner when it’s creating the task.
So if you all have run in to this, and have an answer, please comment here. If we come up with a true solution, I will update my post.