From your description, PowerApps doesn't show all lists of your SharePoint site. Is it right?
Please check the user that you use to connect to the SharePoint connection has proper permissions on the site. Also you can try to use a user with full control on the site to create the connection, then test again.
I have the same issue: I can create a connection to my SharePoint Online linked to our Office365 subscription, and I can add a data source from this SharePoint site collection. However something very strange goes on:
I see a choice of 30 subsites/lists in total, could it be that there is a limit to the items returned by a connection to SharePoint Online?
Below is the end of the choices as I see them, with the red circled sub-site not existing. This sub-site is not even in the second-order recycle bin and does not appear anywhere in SharePoint Designer.
I am the site collection administrator so I have full rights on everything.
Any idea what is going on and how to work around it?
The sites under Recent sites are not the subsites of a site collection, are the sites which are used recently with the same connection.
If I connnect to a connection and a site, I could see more than 30 lists. Please check if you have permissions on the lists which are missing.
If I delete a list, and connect to the site in PowerApps, the list doesn't appear.
Currently, I am using PowerApps 2.0.430, please check your version number, make sure you are using the latest version.
Thank you. I have now upgraded to 2.0.430 but still have issues. The items under recent sites are not just sites, but continues to be a random mixture of sites and lists and folders. Please look at the screenshot in my original post, you will see Shared Documents and even Shared Document folders appearing in the list. It still only shows 30 items in total.
What has changed is that I no longer get an error when I choose a non-existent site, it shows instead a menu of lists that are actually in the parent site of the non-existent site. If I select the the list I can connect to it and it works normally, but this behaviour makes it difficult to find the data I want to connect to because it is not clear where it is.
Just to be clear, the issue is with the Recent sites. I have all permissions since I am administrator of the site collection.
I have exactly the same problem. Not all lists are visible in the datasources screen. Is there a solution available yet? I am also administrator.
As has been said before: The list in the screenshot above is just the recently accessed data sources, not a list of all sites or all lists in a site.
You need to enter the siter url into the text box above the list. What happens when you copy and paste the URL of your SharePoint site into the text box? Then you should see all lists in that site. Does that not work for you?
Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200