[Issue Resolved]: How to resolve hidden Query Fields issue in the InfoPath form?

Introduction: 

We implemented the migration of the InfoPath forms from SharePoint on-premises to the SharePoint online environment for a Postal and Parcel company based out of Melbourne, Victoria, Australia. We encountered an issue of hidden Query Fields in the process of changing the InfoPath data connections as per the SharePoint online environment.  

In this blog, we will learn about the issue and its solution that we faced while creating a new data connection to the InfoPath form. 

Scenario: 

• In this migration process, we have to create/update the data connections for the SharePoint list/library which are required for the InfoPath forms. 
  
• We faced the below issue while converting the data connections of InfoPath forms from SharePoint on-premises to SharePoint Online.  

Problem: 

• In InfoPath designer, we have to create data connections of SharePoint libraries to use it in the form. 
  
• Generally, when we create a new data connection it contains two fields: query fields and data fields. 
  
• The issue was when we created a new data connection in the InfoPath form the query fields were hidden as shown below. 

• For connecting to the “User Information List” of SharePoint online, we detected this below issue while creating the data connection.

 

Solution: 

• This issue occurred because the InfoPath form template was the "InfoPath 2007 Web browser Form Template" type. 
•  If we want to use the form to SharePoint Online environment, we need to update its type to "InfoPath 2010 Web browser Form Template". 

Steps to resolve the issue: 

Open the InfoPath form template in InfoPath designer and click on the “save as” button. 

Now choose the “InfoPath 2010 Web browser Form Template” type from the "Save as type" dropdown and save it.

 

Once we update the type of form template the issue will be resolved and we will able to create and use data connection properly. 

Conclusion: 

This is how we can resolve the hidden Query Fields issue in the InfoPath form. Hope this will help you. Good day! 

If you have any questions you can reach out our SharePoint Consulting team here.

[Resolved]: Different issues and their solutions while publishing InfoPath form to SharePoint Online environment.

Introduction

We performed the migration of the InfoPath forms from SharePoint On-Premises to the SharePoint Online environment using InfoPath designer for a Postal and Parcel company based out of Melbourne, Victoria, Australia. We updated the InfoPath form as per the online version, but when we start publishing the form, we encountered some issues.

In this blog, we will learn about these issues and the solutions which we encountered while publishing the InfoPath form. 

Scenario

• We had an InfoPath form with multiple data connections. 
• First, we changed the data connections according to SharePoint online environment then we publish the form to a SharePoint library but when we tried to publish the InfoPath form for the first time, we faced and resolved these issues. 

Issues and Solutions

Problem 1: 

• When we publish the InfoPath form at the end of the Publishing wizard it shows an alert box as “InfoPath cannot save the following form: form name. This document library was either renamed or deleted...” 
• This issue was detected when we tried to publish the form for the first time.
• The issue is "The library is either renamed or deleted..." even if the library is correct in SharePoint online.

 

Solution: 

• To resolve this issue, we need to make changes to the server from where we are trying to publish the InfoPath form template. 
  
• We have to add the "Desktop Experience" feature in the server manager. 
  
• The issue occurred because the "Desktop Experience" feature is responsible for the connection between the SharePoint server and the window server while publishing an InfoPath form and it was not installed in our system. 
  

Steps to add the "Desktop Experience" feature

Step 1: 

Open server manager and click on the "Manage" tab from the top ribbon and choose the "Add Roles and Features" option as shown below. 

Step 2: 

• It will open the “Add Roles and Features Wizard”. 
  
• Here, in the "Features" section we have to expand the "User Interface and Infrastructure" and select the "Window Experience" feature and after completing the steps of this window we need to restart our server. 

Now the error will be resolved and we will be able to publish the InfoPath form.

Problem 2:   

Sometimes we detect this issue. 

• When we publish the InfoPath form, at the end of the Publishing wizard it shows an alert box as “InfoPath cannot save the following form: form name. Access Denied...". 
• This issue occurs when we try to publish the form for a site that is not a trusted site in our system. 

Solution: 

• To resolve this issue, we have to add the targeted site to the "trusted sites". 

Steps to add a site to the trusted sites  

Step 1: 

Open the  Internet Explorer and click on the "Internet Options" as shown below.

 

Step 2: 

• Click on the "Security" tab, then open "sites" as shown below. 
  
• It will open a window where we can add our site and make it a trusted site.

Now the error will be resolved and we will be able to publish the InfoPath form.

Conclusion: 

This is how we can resolve these issues and publish the InfoPath forms successfully. Hope this will help you.

If you have any questions you can reach out our SharePoint Consulting team here.