Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Building apps where data is not shared to common database

(0) ShareShare
ReportReport
Posted on by 5

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:
  • v-xida-msft Profile Picture
    v-xida-msft on at
    Re: Building apps where data is not shared to common database

    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,

  • tharinya Profile Picture
    tharinya 5 on at
    Re: Building apps where data is not shared to common database

    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. 

  • tharinya Profile Picture
    tharinya 5 on at
    Re: Building apps where data is not shared to common database

    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.

  • v-xida-msft Profile Picture
    v-xida-msft on at
    Re: Building apps where data is not shared to common database

    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,

  • Pstork1 Profile Picture
    Pstork1 64,839 on at
    Re: Building apps where data is not shared to common database

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard