Hey guys.
I am struggling with an Update-Exception from a Dataverse table, where users are updating an Option Set attribute for a specific row. The Option Set ist basically a status indicator (eg. "open", "pause", done).
There is a PowerApps screen that inserts those rows into the Dataverse. Which works fine. The update is not working for any other user than the owner of the app/table. So I assume, I need to grant specific rights here. Which I thought did with the help of a new security role:
The affected Tables name is "LA_POSITION"
The error-Message I receive through a monitoring session is here:
{
"duration": 0,
"size": 0,
"status": 403,
"headers": {
"REQ_ID": "xxx",
"Content-Type": "application/json; odata.metadata=minimal",
"OData-Version": 4,
"Cache-Control": "no-cache",
"content-encoding": "gzip",
"Content-Length": 511,
"expires": -1,
"odata-version": 4,
"x-ms-client-request-id": "xxx"
},
"body": {
"error": {
"code": "0x8004f507",
"message": "User with ID xxx does not have Update v
permissions for the cr1ac_position_status attribute in the cr1ac_la_position entity. The cr1ac_la_positionid of the record is 58c77215-19fc-eb11-94ef-000d3ade75eb",
"@Microsoft.PowerApps.CDS.HelpLink": "http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a8004f507&client=platform",
"@Microsoft.PowerApps.CDS.InnerError.Message": "User with ID xxx does not have Update permissions for the cr1ac_position_status attribute in the cr1ac_la_position entity. The cr1ac_la_positionid of the record is xxx"
}
}
}
Sorry for the bad formatted; JSON is not supported.
To sum up:
Users (<> to Owner) can Insert rows into the table "LA_POSITION" but can't update the option set value.
The owner can update the option set value.
What am I missing within the security role and / or in the app?
Update
Double-Checked it with the XLS Data:
1. Update Row
2. Get Error Message
3. Update different attribute in Table worked.
