This SharePoint tutorial, we will discuss one InfoPath issue which comes while opening a SharePoint Online form. The error comes as: An error occurred querying a data source. Click OK to resume filling out the form. You may want to check your form data for errors. You do not have permission to access a SharePoint list that contains data required for this form to function correctly.
An entry has been added to the Windows event log of the server.
The error message looks like below:
Let me explain to you when actually I got the error. We had a production site which was live, we wanted to create a development site with structure from the production site. For that reason, we used a 3rd party tool to migrate the structure from production to development.
Few lists were customized using InfoPath which contains some data connections “GetUserProfileByName”. By using the data connections, we were pulling the current logged in username and put into the field.
Then we saw that the user profile is not properly configured in the development environment. When we fixed the issue the form did not give any warning message, the InfoPath form works as expected.
Read some similar InfoPath tutorials:
- InfoPath alternatives for designing SharePoint Forms
- How to publish InfoPath forms as a content type in SharePoint 2013?
- Deploy Administration approved InfoPath forms in SharePoint 2013
- Make attachment field mandatory in InfoPath Designer 2013 in SharePoint Online list
- InfoPath 2013 show hide section using Rules in SharePoint online
This tutorial, we learned how to fix error, You do not have permissions to access a SharePoint list that contains data required for this form to function correctly.
Hello Everyone!! I am Bhawana a SharePoint MVP and having about 10+ years of SharePoint experience as well as in .Net technologies. I have worked in all the versions of SharePoint from wss to Office 365. I have good exposure in Customization and Migration using Nintex, Metalogix tools. Now exploring more in SharePoint 2016 🙂 Hope here I can contribute and share my knowledge to the fullest. As I believe “There is no wealth like knowledge and no poverty like ignorance”