I am building an app to support inventory auditing that uses the offline capability. When I test the canvas app on my phone as an Admin the inventory info successfully gets entered into the Dataverse table, regardless of offline or online status. When I do the same with a custom user (copy of basic user account) the data fails to sync/patch to the dataverse tables. No errors are thrown, but the data is not added to either the table or the offline copy. The custom security role was give the privileges specified in this Microsoft resource Set up mobile offline for canvas apps - Power Apps | Microsoft Learn. Does anyone know what might be causing this?
You said you created a security role, but that you gave them Basic User rights.
Unfortunately basic won't have access to custom tables and only certain rights to others.
I would verify under the Basic User Role, look at your tables, and see what rights it has. Issue is probably there, since you said it works fine as the Admin
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
WarrenBelz
146,587
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional