SharePoint Products TechCenter >
SharePoint Products and Technologies Forums
>
SharePoint - InfoPath Forms Services
>
Infopath, workflow and sharepoint List.
Infopath, workflow and sharepoint List.
- Hi All,
The process that i am working is I have a browser enabled Infopath 2007 form which is filled in by the user's and the data in the form is stored in a Sharepoint list.
I have a list box in the form which has some values in it. While publishing the form i have promoted the list box (Problem : Say if i have 5 values in that list box, in the Form Library column i am not getting all the 5 values). Once the form is saved i am running a workflow to get the values from the Form Library and submit them to a Sharepoint list, the column in the Sharepoint list is a "Choice Column" with "allow multiple selections" and "Allow Fill-in choices" both enabled.
Thank You.
All Replies
- When you promoted that field during the publishing process, did you choose the merge attribute in the pulldown at the bottom? If you let it default to "first," then it will only show the first value of the repeating field. If you choose merge, then it will display all the values of that field in a stacked formation. However, you cannot parse out those individual pieces for later use - it is just a block of text. I'm not sure if that text will populate a column like that in another list.
SharePoint Architect || My Blog - Hi Clayton,
I could not find the option "merge" while promoting the field.
Can you explain it a bit more and also i have a screen shot and uploaded it to
http://picasaweb.google.com/chigullapalli.satish/UntitledAlbum#5400665331896186002
thanks. - Then it's not a repeating field. How are you putting multiple values into a non-repeating field?
SharePoint Architect || My Blog - It is a list box.
I actually have 5 different list boxes with different items and the user can select the items and the selected items are populated into 1 list box.
And i want to store these values in the sharepoint list.
I had followed the example at the below link to move items between list boxes.
http://www.bizsupportonline.net/infopath2007/programmatically-move-items-between-two-lists-infopath.htm
- Is there any thing else i can use to collect the values from 5 list boxes?
- I'm not sure what that is accomplishing. A single field can only have one value. If you combine values into one field, then it's just a long text string. If it's a repeating field with 5 repeating values, then that's different. I don't know what you can expect to do with single field that has 5 values stuffed into it when you go back to SharePoint. I don't think I understand what you're really doing (or trying to do).
Is there a reason you can't just let the user choose an item in each list box, and then promote each of those fields individually?
SharePoint Architect || My Blog - Thought about it some more, and I realize you're trying to take these 5 SEPARATE values and push them into that other list so that they show up in a field that allows multiple selections. Whenever you have a column like that and actually choose multiple selections, I believe it displays them in the format of
selection1; selection2; selection3
I've found that SP columns are finicky about the data they accept. It has to be in the exact format that it expects. If that is the format it expects in order to have a set of multiple selections, then in your form, I would simply create a field with this default value:
concat(listbox1,"; ",listbox2,"; ",listbox3,"; ",listbox4,"; ",listbox5)
That will concatenate all your listbox choices into a single string delimited by semicolons and spaces. This text could then be pushed into a multi-select choice column and hopefully display. You'll just need to verify the exact syntax of multi-selected items in a choice column.
SharePoint Architect || My Blog - From each of 5 list boxes above the user can select any no.of items they want ( Eg:In the 1st list box i have 10 items and the user can select 5 items, in the 2nd list box there are 10 items and the user may not choose any and etc ect). So i wanted to consolidate all the values that the user chose, so i followed the tutorial above and created another list box which would store all the values that the user chose. And then i want to submit that data into a sharepoint list.
And the reason i chose a Choice column in the sharepoint list is it helps me in filtering the data.
Is there any other way to do the whole process? - Yeah, but I don't know how your fields aren't repeating fields. In SYM's write-up, those fields are in repeating groups. Such fields get promoted as repeating fields and thus have function options. On your screenshot, there were no function options, which tells me it was a non-repeating field.
SharePoint Architect || My Blog- Unmarked As Answer byBlue Diamond Thursday, November 05, 2009 8:57 PM
- Marked As Answer byBlue Diamond Thursday, November 05, 2009 6:38 PM
- Hi Clayton,
I think now i understand what mistake i made.
In the SYM's example i will explain what i had done. Lets say in that example i want all the items in the right hand side list box.
So i have to promote the "rightListItemName" or "rightListItemValue". under the reapting group "rightListItem". ---------------- Am I correct?
But in the screen shot that i sent you i was trying to promote the list box itself that is "rightListSelectedItem ". -------------which is wrong.
Thank You. - Probably the case - give it a shot. I'm still not sure that the merged data will help you in terms of moving it to the next list, so you might have to use my above example. Let me know how it goes.
SharePoint Architect || My Blog - Thanks a lot Clayton for helping me out.
I have not yet tried updating these values into Sharepoint list, once that is done i will update you.
Thank You once again.
- Hi Clayton,
for every item that i have in the list box the display name and the value are different.
while promoting i am promoting both the display name and the Value and in the function i am selecting "merge" and in the form library it is creating a "Single line of text" column, but the column is empty it is not getting the values from the Infopath.
Any help. - How are you promoting two things for one field? The "display name" of a dropdown cannot be promoted. It only promotes the value. That's what 'value' means - it is the actual underlying XML value while the display name is just for visual purposes.. I'm again confused by what you mean.
If you promote a field that has data in it, then it will show in SharePoint unless you named the field Description in SharePoint. When you have created your XML file, open it in Notepad and see what value is in that XML node that you're promoting.
SharePoint Architect || My Blog - I had followed the tutorial provided by SYM, so created a group "Category1" and under that created a repeating group "ListItem1" and under that i have 2 field elements one for name "ListItemName1" and one for value "ListItemValue1".
And i had set the list box to get the values from the repeating group ie "ListItem1".
So as you said i tried to promote the repeating group "ListItem1", but in the functions i only have "count". And if i try to promote the "ListItemName1" or "ListItemValue1" i get the function to merge but they do not show up in the form library.
I have added the screen shots to.
http://picasaweb.google.com/chigullapalli.satish/UntitledAlbum#
