Showing results for 
Search instead for 
Did you mean: 

Sharepoint Folder as datasource

Please give ability to use share point folders as data storage.

One drive for business is ok, but for sharing files with others, sharepoint folders would be ace.

Status: Planned
Regular Visitor

So glad to see I am not the only one desperately looking for this.

The OneDrive + flows combo really isn't a viable workaround for me, it would be immensely great.


@Audrie-MSFT please just give us an update, even if this feature is no longer planned for release

New Member

Any news on this? I see it's been in the works for a couple years. I developed a PowerApp for my company but the data source is an Excel spreadsheet on my OneDrive. I don't want to share the spreadsheet on my OneDrive with the entire company. I want to move the spreadsheet to my Sharepoint data library and share it from there. 

Regular Visitor

It's almost 3 years. What is the next update on this please?

Regular Visitor

Is there any possibility to have a reply on this?

New Member

This is very frustrating indeed. I am still using my own OneDrive folder...this isn't an adequate solution. I don't get why this is so difficult to implement as a feature. Please give us an update regarding this matter.

New Member

Still stuck since 2017, omg

Frequent Visitor

any update on this change please? 

Helper II

This is not Planned. Microsoft will not support SharePoint folders in SharePoint Lists ever.  They only marked this as planned to keep the end user recommending the future of Power Apps. 


Don't fall for this !  Power APPS will never support SharePoint folders. Microsoft wants you to use the common data model and not SharePoint lists.

Advocate I

What Larry_Casey said.


I recently went to a two-day session about the power platform, and it became rather clear to me that I'd been using Power Apps "wrong."  I definitely got the impression that they want you to build apps on top of the common data service (CDS), which spins up SQL servers in the cloud.  Honestly, it's a better way to go, because managing what amounts to a database in an Excel file in a Sharepoint folder is objectively bad.  You can add whatever fields you want to a particular instance of CDS, and they've built a function that enables you to import existing data into the CDS.  I also got the impression that Microsoft is desperately trying to catch up to Salesforce, because the mainline PowerApps environment using CDS (i.e. not a canvas app for phone or tablet) looks like a stripped-down copy of Salesforce "apps."  They've even built a primitive data visualization functionality that enables you to embed super-simple visualizations on app tabs, just like Salesforce (except, like 2-3 years behind).

The biggest problems I have with this are 1) Microsoft isn't very clear about their preferred methods for using PowerApps, 2) pricing and how much it costs per "app" or per instance is impossible to find, and 3) (most importantly), most businesses' IT departments are not set up to support (or even enable) this kind of self-service spinning up of SQL databases.  Using PowerApps as it seems Microsoft intends it to be used requires a giant shift in IT policy, practice, and culture.  Furthermore, PowerApps is billed as self-service, but it's really not, at least not for the general business user.  Granted, building PowerApps and managing the data they're collecting does not require traditional app development skillsets, but it requires more than just good O365 skills to do it right and to do it well.  A sort of "in between" tier of employee that historically hasn't been present in organizations' structures is now required: not an IT person, not a strict analyst, but someone who's got a dash of coding skill, a dash of database management skill, a dash of application design skill, and a dash of business analysis skill.  There are certainly people like this present in the workforce (I'm one of them), but I imagine that in all companies but the most innovative ones, people like me have to constantly fight against their IT departments to take advantage of these new tools in the way they're meant to be used.

The two-day session I went to had about 45 people, and 75-80% of them were from IT departments.  So....yeah.

Helper V

@andrewbrick  - Great post! 


I'd take it a step further and say that anyone you can identify in your organization who can create a "Production Level" PowerApp and isn't an "IT" person (university or college education in computer science) is an extremely rare bird.