InfoPath Dev

I am trying to populate a dropdown in infopath form, based on xml returned by a sharepoint webservice. (I know what u are thinking, why code? I need to perform some business logic before populating it) 

The problem i am facing is that I do not know how to add the items to the drop-down.

 I found this,  http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/c9593115-24c1-4c3c-960e-3149916f3fdb

It does exactly what I need, however its not in VB script, and I am not familiar  with converting it over to vb script.

Is there a method or way to clone an item of an item from the dropdown and append to it in VBS.

copyitem = DOM.SelectSingleNode("//my:myFields/my:fldChoices").clone()

copyitem.displayname = "";

copyitem.value = "";

dropdown.append(copyitem)

thanks in advance

hi, when you say

vamirineni87:

based on xml returned by a sharepoint webservice

I used code to query for the data. Its not a list. Its user information from GetAllUserCollectionFromWeb.

It returns an xml file that I want to parse and load usernames into a dropdown. 

I figured out how to parse it and get the list of usernames and the IDs. but having problem populating the dropdown using the usernames as display names and IDs as values.

I guess may be a "append" method of some sort?

Ok, I suggest you to use a reference field of your node and clone it, after that you append it to real node. To do that create a new group like "reference", right click on your repeating node, select reference...

Here some example of VBS :

Dim oItem

Set oItem = XDocument.DOM.selectSingleNode("XPATH").cloneNode(true)

oItem.selectSingleNode("XPATHNameChild").text = "name"

oItem.selectSingleNode("XPATHIDChild").text = "ID"

XDocument.DOM.selectSingleNode("XPATHParent") .appendChild(oItem)

 I have tried something very similar before. However this is the error I get when I try to preview the Infopath (2003) form.

Expected end of statement
File:script.vbs
Line:279
    Set oItem = XDocument.DOM.selectSingleNode("//my:myFields/my:fldChoices").cloneNode(true);

 any ideas as to why this is occuring?

Can you please attach your form template ? when you reply click on option....

 Here you go. The field name is 'fldChoices'

and there is a button that tries to populate the dropdown.

Ok, tell me if it's ok for you.

EDIT: I only have office 2003. So I cannot open the form you have attached.

----------------------------------------------------------------------------------------------------------

The error is minor.
The ; semicolon at the end is screwing things up for some reason.


For this statement
 oItem.selectSingleNode("XPATHNameChild").text = "name"
XPATHNameChild doesnt make sence to me.


if my fields are setup like this, "//my:myFields/my:fldChoices", there are no XPATHNameChild and XPATHIDChild.
So do  I have to create other fields and somehow reference them to the dropdown?

Arf, ok check my image, I add 2 group and I bind my drop down to this group.

Here I save it to 2003 xsn...

You are the man!!!

I never used binding before so, it was kinda confusing when I read binding.

I really appreciate the help.