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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Hide data from the use...
Power Apps
Answered

Hide data from the users - Security in PowerApps

(0) ShareShare
ReportReport
Posted on by 83

Do you know any solution in PowerApps to secure data?

 

E.g. I have a Users Dataverse table (or SP list), where I store user data (email etc.).

I would like to show the user his/her data (if they log in), b

ut I don't want the users to access data to the other users.

Is it possible?

Categories:
  • Ami K Profile Picture
    15,689 Super User 2024 Season 1 on at

    @ervinw is your question in the context of a Model Driven App or a Canvas App (both using Dataverse).

  • EdViegas Profile Picture
    436 on at

    Hi,

     

    I think it's best if you don't handle security in Power Apps. I recommend applying it directly in your data source. For instance, if you're using SharePoint lists, you could manage data access using Power Automate if advanced permission settings are not sufficient for your needs.

     

    If you create a flow that will be triggered by Power Apps, you can access the user's email who is using the application. Then, you could use the 'Get Items' action and filter with OData."

     

    If, on the other hand, your data is stored in SQL Server, I would advise using Row-Level Security (RLS)

  • AR-29081311-0 Profile Picture
    137 on at

    Hi @ervinw ,

    You can achieve this in Dataverse or SharePoint sources by filtering your gallery in the Canvas App:

     

     

     

    Filter(datasource, 'Email field' = User().Email)

     

     

     

    This will ensure that the gallery filters the data and only displays the records associated with the logged in user.

     

    Hope this helps!

     

    Aaron

  • ervinw Profile Picture
    83 on at

    @ARAlmac I think you misunderstood me a bit.

    I mean that, to a working app, I have to provide access to the Sharepoint list datasource, even if it's filtered.
    And consequently the user can see all data in SharePoint.
    @EdViegas You mean by using SQL instead of SP list, it can be done?
    In case of SQL I suppose you have to add read grants to the user to the database,
    so he/she can read all the data, nope?


  • Verified answer
    EdViegas Profile Picture
    436 on at

    The possibilities with SharePoint lists are somewhat limited when you need to handle different profiles.


    In SQL Server, in addition to granting read permissions, you can create Row-Level Security (RLS) rules that, based on the result of a query, enable the user to see or not see each row of a table or view.

    https://learn.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver16

     

  • ervinw Profile Picture
    83 on at

    It seems for me SQL is a premium connector, since all the user has to be preemium member?

  • rubin_boer Profile Picture
    4,843 Super User 2024 Season 1 on at

    hi @ervinw 

     

    have you tried setting up SP to allow users to only see and edit their records?

    • Go to List Settings > Advanced Settings.
    • Scroll down and you will see the Item Level Permissions section.
    • Inside the section, you will see two categories: Read access and Create and Edit access.
    • Under Read access, select “Read items that were created by the user”. This means that each user will only get to see entries they created.
    • Under Create and Edit access, select “Create items and edit items that were created by the user”. This means that each user will be able to create items, but they will only be able to edit items they created.

     

  • ervinw Profile Picture
    83 on at

    Yes I know this option, thats the problem I am the creator of all records. If I set them as creators, than I won't see all of them.

     

    I think maybe Dataverse and Row-Level-Security can solve this issue.

  • rubin_boer Profile Picture
    4,843 Super User 2024 Season 1 on at

    ok you have a problem and i can see why SQL is proposed or dataverse, but you want to keep costs down. How busy is this app of yours? another way may be to have power automate handle the request (run with your (our list user) permissions) that way the only data returned is for that user - not the most efficient but at least elegant and cost effective unless you have a high volume app.

  • ervinw Profile Picture
    83 on at

    Actually its a small app created to HR (Human Resource) department, to manage their educations.
    There are different education which assigned to employees (~ 100 member).
    I think you mean this video:
    Setting Unique SharePoint List Item Level Permissions in PowerApps and Power Automate (youtube.com)
    This seems a bit complicated to me.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 226 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 191 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 167

Last 30 days Overall leaderboard