Sharepoint Designer and Multi Select Fields

Question

First the Background. We are running 2007WSS and I am using SPD 2007.

I have 2 custome lists

List 1 - Names is a list with a single colum (just left it as the default Title and it contains a list of Names of People (it is nothing special or clever simply a text field)

List 2 has 5 fields. The default Title field and 4 multi select fields which are set to lookup List 1 (Title) They are called Team 1, Team 2, Team 3 and AllTeam

The Users add themselves to either Team 1, Team 2 or Team 3.

I am trying to write an SPD workflow that will take the content od Team 1, Team 2 and Team 3 and create and entry in AllTeam.

The Story So far....I can do it for Team 1 (whether single or multiple entries) by simply setting AllTeam = Team 1 the fun starts when I try and combine T1, T2 and T3.

I have tried creating a dynamic String and assigning it to a variable then updating and entry in the list

I have tried assigning each to a variable and concatnating eg. var=T1 then var = var;T2 then var = var;T3 then trying to do an update.

I have outputed the field to the log and compared it to T1 to see if there are any differences.....

Any help would be appreciated (even if it is to tell me it can't be done.

Kenny

Answer 1

Use three different workflow variables and build dynamic string to join them. Single variable will not work as expected.

The other way around is create three new columns in your list as single line of text and name them Team1Users, Team2users & Team3users.

In your workflow update these fields with Team1, Team2 & Team3 values.

Change AllTeams column as calculated column and use this formula  =[Team1Users]&[Team2Users]&[Team3Users].

Hope this helps.

Answer 2

Thanks for the reply,

I have tried every combination of building strings and dynamic variables and they just don't work, unless I am missing that all important comma from the string.

The reason I have done it this way is that the allTeam colum is used as a filter for another list so it has to be somthing I can use to filter on. it allows people to get an individual view of what entries they feature in the List2.

Answer 3

Just in case anyone is interested I got round the problem by using the web part connections. The requirements was to show all the information on one page for an individual team member. So this is how I did it.

Create a web part page and put 4 web parts on the page.

1. Web Part with a list of names

2,3,4 are views of the second list each filtered on one of Team 1 Team 2 or Team 3.

I then use the web part connection capability to pass the name from Web Part 1 to each of the other web parts so selecting a name it filters for the name.

I then pass a variable to the first web part via the URL hence when the page opens I see the page filtered for the specific name.

To make it easier I have added a Teams button to the original list to pass the variable via the URL.

Result is as required without using workflow.

Kenny