Unsupported expression in good old InfoPath

Even though Is been announced that InfoPath is deprecated, but supported until April 2023 you can read more here  the reality is that there is a significant amount of customers that still rely on the InfoPath form based solutions for dealing with data entry challenges in the organization on a daily basis. As a consultant, I currently support multiple clients on InfoPath Form related issues. Today I want to talk about a recent discovery and of course share the solution. This is a custom list with an InfoPath list form used for storing OA’s (Operational Activities) assignment information, of course, … Continue reading Unsupported expression in good old InfoPath

Formulas to get the first and last row on a repeating table in InfoPath

You know, you wake up knowing that is going to be a wonderful day working for a customer with the software products you love. During today on-site support session, you found out that is needed to write some good old XPath formulas on an InfoPath form. There is a repeating table with the columns necessarily to describe travel information like Departure Date, Return Date, City, you named and the requirement was to expose the initial Departure Date and the last Return Date of the entire trip, so, what do we mean with entire trip? I maybe start a trip from … Continue reading Formulas to get the first and last row on a repeating table in InfoPath

Wake Up, Lazarus

You will not believe, but I’ve been so busy that didn’t had chance to write a post about the Release Candidate of SharePoint Server 2016 announced by Bill Bear on Jan 20, 2016. Now we can get more serious on evaluating SharePoint Server 2016 for our production environments. If you are interested, please take a look on this announcement. SharePoint Server 2016 and Project Server 2016 Release Candidate available Also, please read Dan Holme point of view on the RC and SP16, it has a valid point! NOTE: Notice that InfoPath 2013 and SharePoint Designer 2013 will match support lifecycle for SharePoint … Continue reading Wake Up, Lazarus

How to create hyperlink that open InfoPath client software a.k.a InfoPath Filler

Today was my second on site visit of the year and during my visit I was requested to fix one of the most frequent issues you will find when building workflow based solutions using SharePoint Designer and InfoPath client forms. So an email activity in the Workflow Designer has a Hyperlink that it supposed to load a InfoPath form instance when the user clicks, in this scenario, the InfoPath solution runs in InfoPath Form Filler so when the users clicks the hyperlink it should load InfoPath Filler client application. Turns out that using Encoded Absolute URL field that has the … Continue reading How to create hyperlink that open InfoPath client software a.k.a InfoPath Filler

Discover SharePoint Web Services methods and parameters and feel nostalgic about it

This is not the first time that a customer has an issue with SharePoint Web Services “. asmx” and InfoPath Forms that I need to quickly spot and fix. Of course SharePoint Web Services work as a charm, but sometimes the problem comes more to InfoPath forms how they consume the services SOAP response and request headers. Yes, I’ve said InfoPath. A lot of customers still work and use InfoPath forms, they created and automated HR or IT process using these wonderful technologies and we, support engineers need to support. A lot of customers still have a dependency on InfoPath. … Continue reading Discover SharePoint Web Services methods and parameters and feel nostalgic about it

Deploy InfoPath Forms with UDCX files in multiple SharePoint farms

Probably you follow the best practices when building InfoPath Forms solutions. You know, there is a recommendation to use UDCX files a.k.a universal data connection files to describe the connection details of a data source. That is all good stuff, the point that I want to share today, is how to deal with InfoPath Forms that have data connection files that need to be deployed to a different farm like from DEV, QA, UAT and PROD farms. Of course each farm as a different DNS, for example: Development Box: http://myspdevbox1 Test Farm: http://preportal.mycompany.com Production Farm: http://portal.mycompany.com So, my InfoPath form … Continue reading Deploy InfoPath Forms with UDCX files in multiple SharePoint farms