InfoPath Dev

I need to set a value on a dropDownListbox to the first list item.  This list box is retrieving items from a webservice. But always show up the blank item after the data retrieved. Any one knows how to auto-Select the top 1 item or remove that blank item from the lists?

Hi snow.snow,

You can set the default value of the dropdown list box to the item in your secondary data connection. That will display the first item in the list. The formula should look something like:

xdXDocument:GetDOM("TestList")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[1]/d:Title

Where "TestList" is your secondary data connection and d:Title is the field used to display the items in the dropdown. While [1] is manually added in the formula.

Thank you Jo-anne,

the dropdow list has filter in the Title, so the top one in the secondary data connection some time is not in the filtered data lists(the #1 in the secondary data is not in the dropDownListbox items)...

Thank you Jo-Anne,

I got it. I add filter and select the top 1 title.

xdXDocument:GetDOM("TestList")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Title[contains(../first_name, xdXDocument:get-DOM()/dd:FirstName)][1]

:)

Thanks

Glad it worked! =)