Difficulty connecting to datasource in PowerApps

William Thompson

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:

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.

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

Alex Wong

@William Thompson
I have created PowerApp that connects to SharePoint list and Azure SQL Database and have no problem. Microsoft List is just a “rebranded” name for SharePoint list, so I don't think your problelm is Microsoft List.

It may be a “one-off” issue with Microsoft server at the time you were doing this, so I think you should just try again later.