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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Users are unable to se...
Power Apps
Unanswered

Users are unable to see and access each other's records in Dataverse table

(0) ShareShare
ReportReport
Posted on by 44
Hey there,
 
I have a Dataverse table whose contents are populated through a PowerApp, and are then modified using a Power Automate flow.
 
I have two user accounts with per-app licensing, and my own premium developer account using this table. While looking at the records in Dataverse, I can see everyone's records, but I can only view or modify my own records when using the App or running the Flow.
 
Likewise, the other two accounts can only see and modify those records that they created when using the app.
 
In the evironment settings a custom security group has given all members full access to the table at the organization level using a custom security role.
 
All members are part of the same business unit.
All members are in the same security group.
The security group has been assigned to a Team that has been granted access to the custom Moblie Offline User security role AND the Basic User role.
 
This is an OFFLINE app. All permissons to offline tables needed for the app to load without errors have been granted to the security role.
 
 
What other tables or settings do I need to consider in order to ensure that everyone can view and modify all records created?
 
 
Additional information:
 
I am genuinely more confused. I have a second app (not offline) that uses the same table. I am able to access all records (both my own and from the other two users) using this app, but not with the offline app. I've also realized that I can see the records using the app as long as I am using the browser version. I also believe I was mistaken that I was not able to send records that were not my own through the flow. I have reattempted it by resetting the submission status (one from my own, one from another user) and it returned that two were sent.
 
Thanks,
 
Dev's Dev
 
 
I have the same question (0)
  • MS.Ragavendar Profile Picture
    4,929 Super User 2025 Season 2 on at
    Users are unable to see and access each other's records in Dataverse table
    Hi,
     
    Check roles in Power Platform Admin Center → Environment → Settings → Security → Security Roles.
     
    Each user needs a role that grants:
    • Read, Write, Append, Append To privileges on the table.
    • Access Level set to Organization (not User or Business Unit).
    If it’s set to User, they can only access records they own.
     
    If it’s Business Unit, they can access records owned by users in the same BU.
     
     
    Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
  • Bezanca Profile Picture
    416 on at
    Users are unable to see and access each other's records in Dataverse table
    Hey,
     
    What security roles do the users have? Have they got standard roles or custom roles? Within the role check what access level it assigns for your custom tables. If it says ‘user’ level access, then change this to ‘organisation’. 
     
    Thanks
    Adam
  • Dev's Dev Profile Picture
    44 on at
    Users are unable to see and access each other's records in Dataverse table
    Thanks @MS.Ragavendar and @Bezanca, but as I stated in my original reply the table is set to Full Access. I edited my reply to illustrate this is at the Organization level.
     
    Please let me know if you have any other ideas.
     
    Thanks
    Dev's Dev
  • Verified answer
    Dev's Dev Profile Picture
    44 on at
    Users are unable to see and access each other's records in Dataverse table
    Finally solved this issue...
     
    The offline profile was set to only download Users rows
     
    I changed it to Business unit rows.
     
     
    It still eluded me why it was not working until I realized I needed to publish the profile.
     
    Hopefully the next person developing a multi-user offline app will flounder less than I did!
     
     
    Thanks,
    Dev's Dev

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 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard