Microsoft 365 – InfoPath forms – resolving error : The amount of data that was returned by a data connection has exceeded the maximum limit that was configured by the server administrator – error while adding new item to list

Hi All,

Greetings for the day!!! Today new small issue and solution 🙂

Background :

• We have migrated SharePoint sites from SharePoint 2013 On-Premises environment to SharePoint online
• In migrated site, for few of our lists we are using InfoPath forms
• When we migrated, we did unit testing and it seems everything is working fine
• Migrated InfoPath forms are also working, we could add new item / view item and can successfully edit item
• Suddenly InfoPath new form for list stop working and following error / warning occurred – we are trying to add new item to list but couldn’t add

Issue / Error :

The amount of data that was returned by a data connection has exceeded the maximum limit that was configured by the server administrator

Click OK to resume filling out the form. You may want to check your form data for errors.

The amount of data that was returned by a data connection has exceeded the maximum limit that was configured by the server administrator. Form elements such as drop-down lists, may be blank

An entry has been added to Windows event log of the server. Log ID:7894

Solution / Cause of an error :

• On our form for one of the column we are fetching data from another list and we have InfoPath data connection for the same
• This error is causing because – data size which we are pulling on our InfoPath form through data connection
• We have data connection – which querying to the lookup list and getting few columns data, sort based on ID column
• By default, the data connection response size is set to 1500kb for Form Services
• But in Microsoft 365 / SharePoint Online, we can not change the Data Connection response size value
• Also in Microsoft 365 / SharePoint Online, its not possible to check the data size which we are getting from Data Connection
• So here in our case we are getting data size more than the default limit – 1500kb
• One possible solution is – to reduce the data size we are getting from Data Connection – we can achieve this by reducing number of columns we are fetching (columns which are not required)
• To update the data connection we need to install the InfoPath client so that we can either edit the respective forms or data connections
• We have removed unused fields and published the form and our new form / new items are created successfully 🙂

Changing Data Connection response data limit in SharePoint On-Premises :

• Navigate to Central Administration

• Navigate to General Application Settings as shown in above fig
• General Application Settings >> InfoPath Forms Services >> Configure InfoPath Form Services

• Change / Increase the Data Connection Response Size default value

Best Practice / Solution – Identify all the InfoPath forms and migrate them to Powerapps forms / SPFx components

Thanks for reading!!! Please feel free to discuss in case any issue / thoughts / suggestions / questions !!!

HAVE A GREAT TIME AHEAD !!! LIFE IS BEAUTIFUL 🙂