Wondering if there is a possibility to build an app in which the data can be stored only to the user's Onedrive rather than syncing to a common database? For example, an app for a personal notebook, where the users who have the access can download but the data is completely private to them.
I'm new to Powerapps. I just tried building a basic canvas app from Excel data.
Hi @tharinya ,
Yeah, you are right. Sharing your Excel sheet to your end users could not ensure the Private data to individual users.
Currently, I afraid that there is no way to achieve your needs in PowerApps. If you would like this feature to be added, please submit an idea to PowerApps Ideas Forum:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas
If there is another solution to achieve your needs, I would also reply here.
Best regards,
Hi Thanks for replying.
This is same as sharring the excel sheet right, to save data from the app? I was wondering if there is any dynamic way, but seems like there isn't.
Hi, thanks for the reply.
Yes, I need the data to be stored to the individual user's Onedrive. I want this app to run as a standalone app, so anyone with access to download the app, can fully use it but his data will be private to him only.
I'm trying to build the app which has the feature for personal notetaking. So, then the data entered must be private to the user itself.
Hi @tharinya ,
Could you please share a bit more about your scenario?
Do you want to create an app where the data could only stored to individual user's OneDrive storage?
If you want to create an app where the data could only be stored to individual user's OneDrive storage rather than common database, I afraid that there is no way to achieve your needs currently.
Currently, a PowerApps app replies on the data source added within this app, there is no way to add data source dynamically within an app when running this app.
If UserA create an app, and add his OneDrive as data source within this app, this app would use UserA's OneDrive as data source, any one wants to access this app, he must have proper permission to UserA's OneDrive (Folder or File). These end users could not add their own OneDrive as data source within this shared app dynamically.
If you would like this feature to be added in PowerApps, please consider submit an idea to PowerApps Ideas Forum:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas
Best regards,
If you build the App using an Excel Spreadsheet in OneDrive you can have every user store the same spreadsheet in their OneDrive. In thta case the data will all be seperate.