cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jup
Helper II
Helper II

Can't find SharePoint list / Can't connect to list

Hi all,

 

I want to connect from PowerApps to a custom list in SharePoint (cloud).

If I add a new datasource and choose "sharepoint" I have to insert a sharepoint-website-url.

When I'm using the base sharepoint-url "https://<companyname>.sharepoint.com" I see some (system generated) lists.

I can't find my custom lists I created within sharepoint.

The direct List-Url does't work, too ("https://<companyname>.sharepoint.com/xyz_Test/Lists/TestCustomList/AllItems.aspx").

 

If I click on "create PowerApp" directly from the sharepoint list Powerapp will open and creates correctly a new app with the list's data. This works correct but as described above if I will MANUALLY insert/connect to this list I cant find them.

 

Please help!

 

Thanks a lot,

jup

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-micsh-msft
Community Support
Community Support

Hi @jup,

 

You need to specify the URL to the proper SharePoint site (or Subsite). Take your testing lists as example, the lists URL is:

"https://<companyname>.sharepoint.com/xyz_Test/Lists/TestCustomList/AllItems.aspx"

We should specify the Site URL with the following:

https://<companyname>.sharepoint.com/xyz_Test/

Please take a try and see if this would work.

And if you need any further help on this, please post back.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
v-micsh-msft
Community Support
Community Support

Hi @jup,

 

You need to specify the URL to the proper SharePoint site (or Subsite). Take your testing lists as example, the lists URL is:

"https://<companyname>.sharepoint.com/xyz_Test/Lists/TestCustomList/AllItems.aspx"

We should specify the Site URL with the following:

https://<companyname>.sharepoint.com/xyz_Test/

Please take a try and see if this would work.

And if you need any further help on this, please post back.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi, when providing the URL to a top level site collection, flow is able to detect the lists, however this does not work for subsite URLs. Is there a fix planned for this anytime soon? 

Hi @sidfadnis,

 

Subsite URL works from my side:

5.PNG

There might be some limitation regarding the sub site type, would you please share more details for the subsite that you have created?

I just choose the default settings when New a subsite.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

thank you for the reply. the subsite I have created is of type "Blog", and I am trying to send an automatic email on creation of a new blog post (new list item in the list /Lists/Posts/) within this subsite. 

No matter how i type in the URL (Not copy and pasting either),  https://<company name>.sharepoint.com/depts/IT or https://<company name>.sharepoint.com/depts/IT/, flow cant find it within itself to actually work. i can type that address in a browser and it finds it just fine. Ive tried this on IE, Chrome, Edge with no luck. Flow is so buggy its rediculous, i mean, how hard is it to find a site if you provide the URL? Cmon MS, yall gotta do something about this, SPD would ALWAYS find my site

I have the same problem. The connection between SP list and Flow worked, and then, after I have spent few hours configuring the list--- bam... the list is no longer seen.  Whatever ways of selecting things I choose - nothing works. 

 

Flow is a great idea but it is too buggy. And there is no way to manually point Flow to the DB.  No buttons like "get a new connection id" no troubleshooting. I will not make another list for another hours just to see if this time Flow will gave enough sympathy to not crash and burn...  Any ideas how to manage this?

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,384)