I am sure this post is not really new, but i would like to share some thoughts with you. I had to create a InfoPath fom which contains a lookup / dropdown to another SharePoint list – a calendar. In the lookup there should be all the starting times of the calendar which are greater than today. No Problem with the filtering possibility in InfoPath.
I created a dataconnection to the calendar list, then i added a dropdown to my form and choose the dataconnection as source. I set the filter to starting date (Event Date) to greater than today and the result does not make me smile:
Can anyone tell me why the output is so unpretty? I expected to get a format like 17.05.2012 13:00:00. Anyway why can’t i tell the dropdown how to format the values? I can’t show this my client and tell him “Well that’s SharePoint o InfoPath”. So i tried it several things till i came to the desired solution.
The source is the source
That’s true for this. At first you have to create a calculated column in your calendar list with this formular:
Remember that english / german might need other formulas like a semicolon instead of a commata or at the date format.
After that i updated my data connection in the form and added the new column. Now i can choose that the new column should be the display column in my lookup and it will display the values like i wanted:
Great, it is possible with a little trick with standard features, but it surprised me that i had to use this workaround.
..:: I LIKE SHAREPOINT ::..The article or information provided here represents completely my own personal view & thought. It is recommended to test the content or scripts of the site in the lab, before making use in the production environment & use it completely at your own risk. The articles, scripts, suggestions or tricks published on the site are provided AS-IS with no warranties or guarantees and confers no rights.
He is Consultant for SharePoint Solutions for collaboration, communication and business processes. He provides his customers applications based on standard features as well as development or combining the power of several microsoft tools like Dynamics CRM. In his free time he tries to collect tipps and worthy experience in this blog.