InfoPath 2010

Re: How to auto select the top(1) item for a dropDownListBox

Jo-Anne Alfafara — Mon, 16 Jan 2012 15:07:46 GMT

Glad it worked! =)

Re: How to auto select the top(1) item for a dropDownListBox

snow.snow — Mon, 16 Jan 2012 15:02:42 GMT

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

Re: How to auto select the top(1) item for a dropDownListBox

snow.snow — Mon, 16 Jan 2012 14:55:15 GMT

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)...

Re: How to auto select the top(1) item for a dropDownListBox

Jo-Anne Alfafara — Mon, 16 Jan 2012 14:29:25 GMT

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.

How to auto select the top(1) item for a dropDownListBox

snow.snow — Mon, 16 Jan 2012 13:30:44 GMT

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?

Thank you!