Some of you might shiver now, but this blog post is about InfoPath! Yes! That old form application I still think it’s good though for on-prem customers who don’t have PowerApps available. I built a form that I needed to validate before the user press “Submit” and the validation is to check if mandatory fields has …
Tag: InfoPath
Learn how to use SharePoint lists as data connections in InfoPath and how to use that as cascading drop down lists in InfoPath. Often when I build forms I find it very useful to have SharePoint lists as lookup information, both because it is easy to setup and also the users can change the information …
This is an instruction on how to connect an InfoPath form with the user profile web service to query the AD and get user information into the form using Claims authentication. Applies to SharePoint 2013.
I have a form with a selection box where the user selects a Role, and based on that Role I set a multiselect field with the predefined values, in this case Applications. What I wanted to do, was to have the checkboxes selected by default OR not display the checkboxes at all. Because this should …
10 April update: That last version 5.1.7322.8 did not help solving this issue with InfoPath. It seems like the problem with templates has to do with forms that uses Data Connections. There is a new version 6 out that I have not installed yet, will come back with an update after that.5 March: Awesome news! …
To get a value AFTER a charactersubstring-after(FieldName, “;”)This will return all text after the character ; To get a value BEFORE a character substring-after(FieldName, “;”)This will return all text before the character ; Substring and Concatenate I often use Concatenate to join text from two fields. For example, the Date function now() has a “T” between Date …
To extract the day number of a date number(substring(DateField, 9, 2)) To extract the month number of a datenumber(substring(DateField, 6, 2)) To extract the year number of a datenumber(substring(DateField, 1, 4)) Calculate hours addSeconds(now(), 7200) Get the month name from a date (and time) field =TEXT([DateField];”mmmm”) Get three characters of the month name=TEXT([DateField];”mmm”) Sort or group …
This post is more for my own memory, since I tend to forget how I solved it when I get this message “Form has been closed” when submitting browser forms in InfoPath 🙂 Scenario is the following:You have a mail view that you wish to mail instead of the default Edit form, so that you …
If you connect a secondary data source to your InfoPath form, and connect to a udcx file which contains a large amount of data: then you might get this error message inside the form: Very irritating! I did not find any solution to it, only that you can disable the script debugger in IE, but …
I have built many forms in InfoPath 2007 and you always find new interesting issues to deal with =) When you think you have found a brilliant solution, then you can be sure that there is an obstacle when it comes to web enabled forms. So it works with filter on data sources. I wanted …
About
