Symptoms
Drop Down List
Diagnoses
When you have an existing Sharepoint List containing a "Person or Group" field with multiple values. The usernames stored in this field need to be loaded into a list controller in K2 Smartforms (e.g. Drop Down List or similar)?
Resolution
- Instead of using Group titles hosted on the Sharepoint this was then changed to use Sharepoint Groups, to allow us to use the URM smart object.
- Within the Mail event, configure the destination rule and run this advance mode.
- Destination Rule options (1st screen) select “Plan Per Slot (no destinations)
- Destination Rule options (2nd screen) select the check box “select a list field to determine how many slots should be created”.
- Within the context browser select the join function and for configuring the function in the Values select “URM2 Find Group Users.Email, this will be emails of the users within the group. Double click on this and configure the input mappings to be the label name and the Group name to be “ActivityInstanceDesInstance”. In the Separator put ‘’.
- Back to the email event itself – using the URM smartobject select the method “find groups and users, email” and double click this to configure the mappings.
- Input mapping configure the label name to be = “SP” and Group Name to be the “ActivityInstanceData”
- In the filter we select the Email Is not Not Null and selecting the return property to be the email. Also add another filter option to say And ‘Email’ <> contains an empty string.
- Furthermore drag in a data event into the same activity and we create a datafield one to host the Groups and one for emails. For the source select the ‘Activity Destination Instance’ and for the destination select the Group datafield. Again within the data locations we select the Email data field that we previously created in the Destination and as the source we put ‘d’.
- You can save and deploy this and you will see that the emails get sent to all the relative users within the groups specified.
