.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

infopath 2007 Expected value type: end-of-string ! calculated field

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :SharePoint
Hello I am using infopath since there is no field with type date and time in InfoPath 2007. I created three fields one for date one, for hours, and one for minutes then I created forth field that concatenate the values of the three fields this field will be used as column in form template library used by my form. All seems good so far but when I tried to concatenate those fields go the following error Expected value type: end-of-string how can I solve this ? my xpath looks like ../my:calmomoDate../my:cbmomoHours:../my:cbmomoMunites Thanks  Momo

View Complete Post

More Related Resource Links

How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

SharePoint 2007 to Access 2007 - Issues grouping by "Person or Group" field type/column

We are on SharePoint 2007 and using Access 2007.  The SharePoint list contains a column called Assigned Person, column type: Person or Group, single selection, displaying only the name 1) When we Open with Access and Export a copy of the data, then create a report from that table, we do not have the option to group on Assigned Person.  2) When we Open with Access and Link to data on the SharePoint site, then create a report from that list, when we group by Assigned Person... The same person has 2 groups - there are is no other grouping or sorts on the list, and i can't locate a correlation to another field to show why they would have to collections for the same person The Person or Group column sorts "from smallest to largest" as though it is a number field. The list is a task/activity tracking system we created custom for our needs.  We want to pull a weekly report, grouped by Assigned Person, but cannot get access to work.  We do not want to resort to anything more complex, as it takes a much longer process to have reports pulled by Chrystal or one of those types of applications.  And we cannot change out the field for something like a Choice column as the list already has a very large amount of content.  Can anyone assist? Is there a setting hiding somewhere that is causing the problem? 

Calculated column and hyperlink field type

Hi I have customer who is asking me if this is possible to provide filter based on the HyperLink field, where he could easly limit results to only those items where link field is filled. As filtering on hyperlink column type is not supported I was thinking to buld some calculated field based on it to return YES (if link is provided) or NO (if link is not provided). The problem is that hyperlink field type is not avialiable on the list of field to be used on calculated field. is there some workaround for that ? thanks for help   Mariusz Gorzoch Blog : http://mariusz.gorzoch.pl Twitter : http://twitter.com/MariuszGorzoch Facebook: http://www.facebook.com/mariusz.gorzoch

Is there any way to populate an InfoPath form field with the data from the site content type column?


I have a Form library with a form template.

The templat has a field "Office name" which should not be a fixed list of values, but a dynamical list, feeded from a different type of form. I'm a novice with InfoPath - Sharepoint and I want to find out, how can I can give users a possibility to create and maintain a list of offices and also have this list as a selection list inside main library form - ALL inside one library, if possible.

I assumed that if I publish main form (Itinerary) as a library template form and lookup form (OfficeInfo) as a SiteContent, I should be able somehow to connect to siteContent column and it's information. But I cannot see how - Site Content Gallery is not appering as a Connection item.

Can I use SiteConenct for this purpose or there are other ways to create end-user lookup lists?

Thank you!


InfoPath 2007 Form Content Type does not save as infopath form but as xml document.


I have a couple of infopath forms deployed to sharepoint as content types. Normally, when a user creates a new document of an infopath content type, the form opens in browser mode and ,when the user fills in the form and saves the form, a new document is created in the document library with the correct icon and progid.

This was before... Now, whenever I save a form, the form submits correctly, i see the file in de document library, BUT it has the icon of an XML document, all the infopath functionality is gone and when I click the file, I get a save as dialog...

The form itself hasn't changed that much and even when I redeploy a version that worked before it still does not work. However, when I create a new doc lib and associate the malfunctioning form there, the behavior is normal and i can still reopen the saved form.


Little sidenote: I have 7 different forms that now do not work on my test machine. It used to be only one, but after redeploying them, all of them have the same problem. Now when I deployed these forms in a production environement, the same thing started happening there. So I stopped the deployment and in production there is just the newly deployed form that does not work.

I have already tried reassociating the form to the doc lib. And everything looks normal in central administration.

Any suggestions?


# string with cross site lookup field value of List in datasheet view in moss 2007

I am getting appended # code value with cross site lookup field value of List in datasheet view, and also i am getting this value while export to Spreadsheet. How to remove this value.....

# string with cross site lookup field value of List in datasheet view in moss 2007


I am getting appended # code value with cross site lookup field value of List in datasheet view. I dont want that hash coded value, i need actual value. Please provide me the solution.



Rajanikanth Rayala

Contact Field Type . InfoPath > SharePoint


I managed to create contect field in IP form, then separate it into 3 text fields, which are then linked to sharepoint library fields.

It`s fine, but resulted SharePoint list recieves contacts as text and stores them also like text fields (ad account or name strings).

But i want to see name`s field type of User or Group.

Can that be done ?

updating content type failed during publishing Infopath on MOSS 2007


Hi Folks,
I am new to MOSS & Infopath-2007. I want to publish form on MOSS onto Document Library not as Content Type. Last week, i published form successfully, but suddenly since last thursday, I am not able to publish - it gives me "updating content type failed" error. :(
I am publishing with Domain Trust, no certification is sign (actually, not required in my case).

Thereafter, I tried creating new template with single button/textbox, but it gives same error.
Today, i tried with blank form, it failed again with same error.

I tried creating Form library from Infopath form as well as from MOSS, but no help.
doing Googling, i only got 2 solution - timeout or too many columns added from infopath - but in my case there are only 3-4 columns i want to publish. 

I tried below links, but no help:

In Infopath - How do you give a name to a calculated field that can then be referenced in other calc


For example.  If I have the following fields


I can created a calculated field

Sum1 + Sum2

This gives the right answer.

But this doesn't work even though the field validates.

Total1 = Sum1 + Sum2

I want to be able to use the "Total1" reference in other fields and formulas.


Total3 = Total1 + 100

How do you do this?




InfoPath Calculated Field doesn't Post to SharePoint List when form is submitted


I have a nice InfoPath form that includes a calculated total field.  That works great.   The form is published to a SharePoint list and when users of the form Submit the form to the list the form information neatly populates to the list.   Well, all of the fields populate to the list except for the calculated total field, that one is just blank.  Naturally, I've noodled around to figure out why and therefore I'm here now asking for guidance.   What should I be focusing on to resolve this issue?


Office Space: Custom Field Types for SharePoint 2007


Custom field types provide a powerful way to define a reusable SharePoint column definitions.

Ted Pattison

MSDN Magazine May 2009

InfoPath 2007: Designing Form Templates With The New Features Of InfoPath


InfoPath 2007 is an XML forms designer and editor, and a fully featured and integrated member of the Office family. This article takes a sneak peek at some of its new features.

Scott Roberts and Hagen Green

MSDN Magazine August 2006

Conversion from string to type 'Date' is not valid



Im receiving a strange error Error Message: Conversion from string "15/08/2010 22:21:35" to type 'Date' is not valid.

I know this is generally down to cultural date formats etc, however the reason this is strange is it just randomly occured twice in the last week, the website has been running since october and nothing has changed,

The error constantly occured until the IIS was reset and recompilled the site, its been running fine since, however im just trying to figure out what could cause such an error to occur.

I've narrowed it down to a line of code which is:

bktime = DReader.Item("Bktime").ToString

bktime = Year(CDate(bktime)) & "-" & fmt(Month(CDate(bktime)), 2) & "-" & fmt(Day(CDate(bktime)), 2)

Has anyone else encountered this randomly occuring and is there anything i can put in place to prevent this in future?



WSS 3.0 Content Type with Office 2007


We're currently encoutering an issue on our production servers with Office 2007 documents. In essence, the Content Type for all docx, xslx, and pptx documents cannot be changed away from the site default on all newly created sites.

I've even done some step by step debugging on an SPItem insert and I can set the content type to a custom type, but it reverts back to the site's default Content Type on Update(). Other file types - .doc, .xls, .tif, .txt, and .jpg - have all been tested, and all work as expected (the Content Type changes correctly).

Thanks in advance!


MOSS 2007 : I am looking for tutorial about how tu use infopath 2007 forms and to associate to them



I am quite new on sharepoint 2007,

i am at the moment looking for tutorial to help to understand better the concept of workflow you can associate with infopath 2007.

I would like to create a  form that the visitor of the website can fill and then submit.

once the form submitted i would like tto be able to store all the date picked up to the database sqlserver 2005 and then to be able to send a email to the administator to be kept inform  of that.

the 2 tutorial i found that i found interested are http://weblog.vb-tech.com/nick/archive/2007/02/25/2207.aspx and the microsoft one o.n the virtual lab.

So what i am looking for is any tutorial which can help me to be understand very well how to use the worklow with infopath or if you have as well some book to advice me for that i would be happy.


how to add vailidation between library field and infopath


 i have a browser enable form with filed mails ids and cost i am promoting these filed, and it's saving in library  but i need a vailidation when if any when to submit  requets using mail and cost , at  time i need availidation that your mail id is already  exit , i create a receiving connection for mail id fields it received fileds how to i compare it


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend