Unanswered

Building apps where data is not shared to common database

(0) Share

Report

Posted on by tharinya

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Pstork1 69,332 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
tharinya 5 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
tharinya 5 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No