web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Creating a new PowerAp...
Power Apps
Unanswered

Creating a new PowerApp, where to store the data?

(0) ShareShare
ReportReport
Posted on by 127

I am trying to create a new PowerApp to get approvals for budgets. I would like to force users to use my application to submit new budget requests, and the request will go through some approval steps based on list data in SharePoint. Users must see the data as read only during that time (but they can submit requests). So How to handle such a situation with Powerapps? Do we manage the security in SharePoint? Or do we store the data in a site where they have permission to everything without telling the users the location of that site and make the data read only in PowerApps? I want the people who can approve to be able to submit requests to this list at the same time. If the request is reject, I want them to be able to edit it again and start another approval process (will be using Flow for the approvals).

 

Any hint will be helpful as I am new to this platform. 

Categories:
I have the same question (0)
  • DanishIslam Profile Picture
    108 on at

    Hi,

     

    You can set the form mode based on request status to Edit or View for requestors. 

  • BrittanyR Profile Picture
    127 on at

    Thanks @DanishIslam .. Yeah I know that, but my question is where to store the data itself? If I set the form to read only, etc.. Users in SharePoint will still be able to go to the list and edit data. So what's the best way to go about it when doing PowerApps projects with SharePoint?

     

  • Verified answer
    mmhailye Profile Picture
    33 on at

    Hi Brittany,

     

    Take a look at this documentation on "Environments".  If you create a new Environment (call it Production Apps for example), then create a Connector to your SP list, and finally connect your PowerApp to that SP connector, then users of your App will have access to the SP list "through the App only".  In SP you can keep the list private with access for you only.

     

    https://docs.microsoft.com/en-us/power-platform/admin/environments-overview

     

    Hope this helps, Mike

  • BrittanyR Profile Picture
    127 on at

    This seems like the solution I actually need! I'll read it and see how it goes. 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard