Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Error adding your data source: SharePoint List

I was trying to create a new app with a connection to a SharePoint list.  When I tried to create the connection to the list I recieved the following error:




I searched for possible solutions in the forum, and tried the solution here:

, which was to add a column in my list called 'dataEntityDefinition', which then returned this similar, but slightly different error: 




I'm not really sure where to go from here, but any assistance would be appreciated.

Thank you!

Resolver III
Resolver III

Hi @ShaSha 


Is this happening with every sharepoint list ? 

Try to create a new sharepoint site and used it to host a new list. 

Resolver I
Resolver I

Try this Workaround:

  1. Export your SharePoint List to Excel
  2. Open the downloaded .iqy Query (Excel will open)

  3. Import the opened Excel List to SharePoint again

  4. In PowerApps try to add the DataSource again



Good Luck!

Hi @ flugaveltem - 


No, this error is not occurring with every SharePoint list.  I actually have another app that is connected to a different list, on the same SharePoint site, which is working fine.

Once the list is exported to Excel, and a connector made to the Excel workbook then the connection is established without errors.  However, I do need the connection to be for a SharePoint list, not an excel workbook, as in my experience some PowerApp functions and features that I would like to employ do not work well with an Excel connector.

What I mean is that you export the SharePoint list to Excel, so you can then re-import it as a new SharePoint list to see if the error still shows.

You are using Excel just for the purpose - after the re-importment you are working with the same connectors as usual.


Good Luck & let me know how it worked for you.

Resolver III
Resolver III

Hi @ShaSha 

Have you try open your app in open an Incognito window ? 

Remove the sharepoint coneection for your app. In app details, go to Connections

Captura de tela 2020-12-14 112750.png

Remove all sharepoint existing sharepoint connections, and try to recreate it. 

If you try to create a app from inside the list, it works ? 



Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,642)