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

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,970)