Tuesday, 6 October 2009

InfoPath 'time' fields promotion - values not shownup in library

Background(if you just want the solution jump to conclusion):

while dealing with InfoPath time fields you may come across this problem when values are not shown up or shownup with minimum date and time in the library(after times fields being promoted).

In SharePoint there's no time field so it creates them as 'datetime' type which causes the confusion. I discoverd two possibe work arounds for this which are mentioned in the conclusions.

These solutions may not be applicable in the scenarios where time fields required to be manipulated as datetime especially with the case of CAML queries.

Conclusion:

Two possible workarounds for this:


1-Change the time field to string and implement validation

2-Prior to publishing, create a site column with the same name as the promoted field with Single Line of Text type. The content type creation will pick the existing column of site.



Hope this will help !



Majid

No comments:

Iconise ‘Add Picture’ control in PowerApps

Default look you get for ‘Add Picture’ control is not very appealing for end user and there is no OTB way of specifying icon for this con...