Applies to Product – Microsoft Dataverse
What’s happening?
Records in the sample "Approval Task" table are being deleted without any trace, despite enabling audit logs and the recycle bin. The deletion is occurring even after removing delete access from end users.
Reason:
The records are not being deleted randomly; instead, they are failing to be created due to errors related to user permissions. Specifically, users do not have the required "AppendToAccess" rights for certain records in the related "User Pack" entity, which is causing the creation of "Approval Task" records to fail.
Resolution:
- Verify that users have the necessary "AppendToAccess" privileges for the "Approval Task" table.
- If possible avoid using "link-entity" in the code when creating records in the "Approval Task" table.
- For further troubleshooting, work with a system administrator to use the Access Checker tool on the affected records.
- Monitor the creation of "Approval Task" records to identify any further issues.