Unanswered

Error adding your data source: SharePoint List

(0) Share

Report

Posted on by ShaSha

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:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Cannot-read-property-name-of-undefined/td-p/570773

, 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!

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

flugaoveltem 217 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ShaSha

Is this happening with every sharepoint list ?

Try to create a new sharepoint site and used it to host a new list.
FrostedFlake 138 on at

Like
a
(0)

Report
Copy link

Link copied!
Try this Workaround:

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

Import the opened Excel List to SharePoint again
https://support.microsoft.com/en-us/office/export-an-excel-table-to-sharepoint-974544f9-94bc-4aa8-9159-97282d256dab

In PowerApps try to add the DataSource again

Good Luck!
ShaSha 6 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
ShaSha 6 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
FrostedFlake 138 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
flugaoveltem 217 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Remove all sharepoint existing sharepoint connections, and try to recreate it.
If you try to create a app from inside the list, it works ?