Converting InfoPath data connections to UDCX files

While working with InfoPath 2013 and SharePoint 2013 on a Windows 2012 platform, I came across an issue where I was not able to convert the InfoPath data connections into UDCX files. I was getting the error below:

The specified location does not exist or could not be opened. Choose a data connection library on a server running Microsoft SharePoint Server and specify a valid filename.

After some read through, I found out that for this to be able to work, I would need a Windows feature installed on the server. This feature is Desktop Experience. Once I enabled this from the Server Manager, and restarted the server, I got rid of this error. Files were then getting converted to UDCX and were published to the Data Connection library.

Hope this helps someone.

Using Filters within InfoPath Data connection

I have been asked a number of times by various community members on how to fetch SharePoint list values within the Data connection based on certain condition, so I thought to write a post about it and spread the word.

InfoPath allows us to create data connections and fetch values from any SharePoint list. We can also select which column values we want to select. The data connection will then return all the items within the list, to control which value(s) we want to fetch, we can apply filters.

filters Click on the Dropdown properties and select/add a Data connection. In the Entries field, click the XPath selector button which will enable us to select which column value we want to bind to the dropdown control.

Select the parent node and click on Filter Data… to bring up the filter choices

Click on Add filter option and then you can select your InfoPath controls to create a condition for fetching the values from the list.

Click on Ok and run the form to verify. The list of values will be based on the conditions being set within the filter.