You’re offline. This is a read only version of the page.
81
To describe the situation. I have a custom table in dataverse that is updated with the data it receives from a power app. I created a specific security role for users who I have shared the app with so that people who enter data only have read, write & create permissions on the table. I, as well as anyone who has system admin writes, can update the table but the people with the custom role cannot. While they are entering the data no message appears indicating that the patch function failed or there was any error, but the data is not in the table. If it makes any difference the environment is still in Sandbox mode. The custom role duplicates App Opener security role with specific permissions to create, read and write to the custom tables. Is anyone familiar with this situation and can explain what I need to do so they can update the custom table?
I found the answer to my own question so for anyone who runs into a similar solution. My project uses two tables, one contains reference values (Reference Table), the other contains the user's answers from the audit (Answers Table). Within the Answers Table is a lookup column connected to the Reference Table. Because of this 1:N relationship the Security Role Required "Append To" permission for the Reference Table and "Append" Permission on the Answers Table. Once I granted the permission to the security role the Answers Table in Dataverse allowed user assigned the security role to update the table. (Security roles and privileges - Power Platform | Microsoft Learn).
Share
Report
All responses (
Answers (
