Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / April 2006

Tip: Looking for answers? Try searching our database.

Getting Data from SharePoint List

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dean - 31 Mar 2006 15:54 GMT
I have a Sharepoint list that contains an calculated field (it concatenates 2
other fields together). This calculate field is not available when I try to
use this list to populate a drop down list. Is this functionality unavailable
in InfoPath? If so, how can I concatenate 2 fields from a WSS list in a IP
dropdown control, or display 2 columns (like I can in Access)?

TIA
S.Y.M. Wong-A-Ton - 01 Apr 2006 17:38 GMT
I think it's by design. What you could do is add an extra (non-calculated)
field to your list in SharePoint and then use this field in InfoPath to store
the calculated values in and display them in the drop-down list box. Once you
have added the field in SharePoint and created a data connection in InfoPath,
you can retrieve the data connection in the OnLoad event handler of the form
and then do one of two things:
1. Loop through all the rows in the secondary data source and fill the extra
field with calculated values using the other fields in the same row, or
2. Create an XSLT that will transform each row in the secondary data source
to contain the calculated field based on the values of other fields within
the same row, and use this stylesheet to transform the entire secondary data
source in 1 step.

The advantage of the second option is that there isn't any looping involved
in code and it will perform better than the first option when you have many
rows to convert. I will post an example of the second option on my website.
---
S.Y.M. Wong-A-Ton

> I have a Sharepoint list that contains an calculated field (it concatenates 2
> other fields together). This calculate field is not available when I try to
[quoted text clipped - 3 lines]
>
> TIA
S.Y.M. Wong-A-Ton - 02 Apr 2006 12:20 GMT
I've posted an example of the second option (see previous post) here:
http://enterprise-solutions.swits.net/infopath/transform-data-secondary-data-sou
rce-xslt.htm


While I've adopted this solution to a WSS list for your scenario, it can be
used to transform data in any secondary data source.
---
S.Y.M. Wong-A-Ton

> I have a Sharepoint list that contains an calculated field (it concatenates 2
> other fields together). This calculate field is not available when I try to
[quoted text clipped - 3 lines]
>
> TIA
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.