Difficulty connecting to datasource in PowerApps

Copper Contributor

There are a couple of ways to connect to a datasource.  One method is to create a Canvas App with the Datasource itself is part of the creation process of the Canvas App.  I will describe my experience with this method soon.  Another method is to create a blank canvas app from scratch, then add a form to that canvas app and then connect to thea torm using your shareport List (or Microsoft List) as its Data Source.

 

When I tried the first method I have mentioned here, when it came time to connect to my Microsoft List data, I got a page describing a problem.  At the top of the page was this information:

 

Sorry-Disconnect-Page.png

(image of page data)

 

 

The session id is: 89fce4a0-089b-11ef-9c95-17cf2d841331 

I have used it as a search string in the suggested support site but I did not get any results.  

 

And now for the second method of connecting a data source to a Power App which is to start with a blank Canvas App and then add a database connection to the app by way of a form.  This method is described in this video https://www.youtube.com/watch?v=H11RFxiDltw which I followed.  But when it came time to add the connection, I got this connection waithing message that has now been on the screen for a couple of hours. 

Please-Wait.PNG

(please wait)

 

I guess there is nothing to do but wait.  It is a good thing it is Friday.  Maybe by Monday it will have loaded and made the connecion.  I am thinking that perhaps since there were many columns in the Microsoft List, it will take a while.  But it was not exactly an exhorbanant number of columns.  It was around 30 or so.   But not thirty thousand.  Is it normal for it to take hours?  I have seen some strange things in the software world like this where, eventhough computations happen at virtually the speed of light, no one accounted for nested loops and the exponential nature of processes like this.

 

What are your suggestion?  Does the session id,  89fce4a0-089b-11ef-9c95-17cf2d841331, mean anthing?  How can I make use of i t?

 

This is part of the low-code or n-code world.  Is there any way I can break that and actually use code to access the Microsoft List?

 

Is the problem in part due to the fact that I am using a Microsoft List as a database instead of an actual SharePoint List?

 

Is there a soultion or another option that I can not imagine, think of, or exists but I am not aware of it?

 

I made a recording just in case one might not believe that this is taking a long time to process.  Here is at least the first 40 minutes.

https://youtu.be/dPEmlaVdGY4 

2 Replies
I haven't tested creating from a Microsoft list myself, however that could be the problem. I haven't encountered issues with SharePoint list unless there are over 5000 items in the list, if that is the case I would explore alternative options for storing your data, such as Dataverse (which is very easy to import and works seamlessly with powerapps). I have encountered the endless "Please wait" a few times, generally a hard refresh and cache clear resolves the issue although you may need to redo your last action, if you have lots of unsaved chages this would not be recommended.
I went over the list and tried a smaller list and I found one data type that might have been an issue and changed it. Through trial and error I got it working.