How can I use a Calculated Column from a SharePoint List in InfoPath

[Paul D. Fox]

I'm creating an InfoPath form and would like to include a Drop-Down field
that displays a Calculated column from a SharePoint List. When I create
the Data Connection, the Calculated Column is not shown. Is this not
possible?

Paul

 

[Anuma(GGK Tech)]

Hi,

I can think of two ways to do this.

1. Create a three column secondary data source that is populating from the
SharePoint list. The first and second columns will be code and description.
The third column will have a formula for the default value, which will be:

concat( code, ": " , description);

2. Add calculated column in SharePoint and take the data connection to get
that field. Please read below link to do this.
http://social.msdn.microsoft.com/Fo.../thread/d610bebb-1552-4a67-b52a-0b23ad7a1e8b/

 

[Swathi (GGK Tech)]

Hi,
We cannot get the calculated columns using the sharepoint list data
connection. To get the entire columns list in sharepoint you can use the
GetlistItems method. Read the following link to know how to implement
GetlistItems.http://www.infopathdev.com/blogs/ag...rm-Library-Using-GetListItems-Web-Method.aspx