You’re offline. This is a read only version of the page.
Announcements
Hello everyone, I recently started working with PowerApps. Currently, I'm developing an application that allows the user to insert/update/delete rows through an Excel-style gallery. The gallery's items are based on a table in SQL Server. Essentially, all user modifications are saved in a collection and then, by pressing a button, all the changes are patched back to the data source (similar to Reza Dorrani's video on this topic). The application works correctly in edit mode, but in play mode, it shows the following error: "You don't have permission to edit/create this row" (edit if I try to modify, create if I try to create a row). The curious thing is that only this table exhibits this behavior, while other tables that I patch in play mode on other screens of the app don't have any issues. The only difference between this table and the others is the approach using a collection. It seems as if, when I enter play mode, the user no longer has the necessary permissions to interact with that table. Is that possible? Has anyone experienced something similar or could guide me towards a resolution? Thanks to anyone who can help me.
This is likely due to some of the read-only columns being in the collection you created. When you then try to patch these back to the datasource, it will try and update those read-only columns, which you do not have permission to do.
Remove any excess columns by only patching the columns you need - use ShowColumns() to select only the columns you need from the collection when patching a whole collection's worth of data.
Cheers,
Sancho
Share
Report
All responses (
Answers (
18,228
