cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aurelijusm
Level: Powered On

Connection to datasources error - An error occurred on the server. Server Response: not a valid connector Error Response

Hi,

I know there are posts regarding this issue, but none of these actually help to solve the issue. A day ago I started facing the error - An error occurred on the server. Server Response: not a valid connector Error Response

  • I am using Sharepoint Online lists as a data source.
  • Error occurs both in PowerApps Studio and while using the app on browser (not using mobile)
  • Windows 10, using Chrome
  • The error occurs when trying to refresh data source or simply retrieve data from it (as example create local collection from sharepoint list)
  • The issue seems to occur with different Sharepoint Lists
  • Tried to remove Sharepoint connector and add it again - no help
  • Tried to disable all experimental settings of the App - no help
  • Tried to clean cache, check internet connection, etc. - no help
  • Sharepoint lists are accesbile fine bo going in directly to the list link
  • Sometimes I get this error, sometimes I don't. Sometimes, before or after getting error, the connection to Sharepoint Lists are super slow, so even though I don't get this error, it is super slow to retrieve the data or refresh the list.

image.png

 

2 REPLIES 2
Microsoft v-siky-msft
Microsoft

Re: Connection to datasources error - An error occurred on the server. Server Response: not a valid connector Error Response

Hi @aurelijusm ,

 

Can you share some formulas or screenshots with your scenario?

Did the error occur after you made changes to your app? Can you share the formulas that call the connection? It may caused by some weird code.

Also, can your other apps call SharePoint connection smoothly? or you can create a new app and check if the connection can work well, so that we can know if the issue is caused by connection or other factors.

Best regards,

Sik

aurelijusm
Level: Powered On

Re: Connection to datasources error - An error occurred on the server. Server Response: not a valid connector Error Response

Hi @v-siky-msft ,

Can you share some formulas or screenshots with your scenario?

-Refresh(DataSource); ClearCollect(collectionname, DataSource); Lookup(DataSource, xx=yy, zz). Not sure about Path/Collect, it seems I haven't received an error on these.

Did the error occur after you made changes to your app? 
-No changes have been made.

Also, can your other apps call SharePoint connection smoothly?
-Same issue with other apps connected to different SharePoint lists.

Like today it seems to be working okayish, haven't received an error yet. Yesterday evening was really bad - super slow connection or getting an error. I have tried to remove Sharepoint connector and add it again - didn't help, just broke all Flows and needed to spend hours to fix them. Please also see topic on the same issue here: https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/unusable-editor-2019-11-22-bug-in-v...
Other people seems to have/had the same issue.

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,463)