Difficulty connecting to datasource in PowerApps

Question

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:

(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)

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

Answer 1

Hi @William Thompson,

Thank you for posting in this community.

Based on your description, I found and tested the official documentation for the two methods you describe. Both methods successfully connect to the Microsoft list.

Method 1: Create an app from within Power Apps

Method 2: Add data connections to canvas apps

Since we can't reproduce your situation, we need to narrow down the problem and try some things.

1.Are other users facing the same problem? View through another computer or account.

2.I suggest you try again according to the documentation. Please note that the URL you connect to should be in this format: https://yourTenantName-my.sharepoint.com/personal/yourAccount.

3.Try to use a different browser or your browser's InPrivate mode to see if the same error occurs.

4.If the problem persists, then I suggest you go to this PowerApps Community and ask the question. There are more specialized Microsoft support engineers for PowerApps there who can help you solve the problem better.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.