Controls

Re: Load Dropdown with Last and first name which are columns in a list

Hilary Stoupa — Mon, 27 Jul 2009 16:02:58 GMT

I'm sorry -- I didn't realize that calculated columns wouldn't be available. I'm not sure how you'd be able to do this without code at this point. Hopefully someone else will know of a way....

Re: Load Dropdown with Last and first name which are columns in a list

mcmadhan — Fri, 24 Jul 2009 06:37:08 GMT

I tried doing it. But when I tried to connect the list to the infopath form using data connection the calculated columns are not listed down in the select column list. I there any way that I can pass through these calculated columns to the form?

Thanks,

Re: Load Dropdown with Last and first name which are columns in a list

Hilary Stoupa — Thu, 23 Jul 2009 19:58:30 GMT

Not that I know of. Can you add a calculated column to your SharePoint list that concats the fields and use that for your drop down?

Re: Load Dropdown with Last and first name which are columns in a list

mcmadhan — Thu, 23 Jul 2009 17:38:04 GMT

the user data are in a sharepoint list as two columns. Could I load both together in a dropdown in the format of "Last, First"?

Re: Load Dropdown with Last and first name which are columns in a list

Hilary Stoupa — Thu, 23 Jul 2009 16:02:46 GMT

Hi --

Can you tell us more about what you are trying to do? Where does the user data that you want to load exist? SQL? SharePoint?

Load Dropdown with Last and first name which are columns in a list

mcmadhan — Thu, 23 Jul 2009 10:43:03 GMT

Hi everyone,

I'm new to infopath and developing a form where I need to load user data in the format of "LastName, FirstName" which forms columns of a list. The form which I develope is browser enabled one.

Would someone help me on the above task.

Thanks,