You’re offline. This is a read only version of the page.
64
I have a couple of views for my table, but in only two custom-views(which are shown as a subgrid in an other table's form) I want my users to be able to edit the values of only one column.
In the other views of that table I don't want my users to have editable grids at all.
How can I achieve this? Thank you
As of today, the business rule to set read only for power apps grid control is now fully broken, i think this is no longer supported :(( BIG thumb down for Microsoft
Hi @Stevieed, business rules are not only for the forms and can run at the entity/table scope and will take effect for editable grids. Give it a try 🙂
How can you do this with business rule? when you looking at the editable grid (view of that table), you aren't opening the form of that table, so business rule has no effect?
Also, in business rule, even when i lock the cell as read only, I can still edit the read only cell when I am looking at the editable grid
This is such a basic excel like basic feature to just allow user to customise editable grid, lacking of this features make so many users struggling and makes dataverse so amature
Yes, that's true. I also try to suggest to use out-of-the-box capabilities/configuration at first opposed to custom (writing code), but JavaScript is useful for complex scenarios, it is only support on editable grids so far, not on readonly grids. More info: https://learn.microsoft.com/power-apps/developer/model-driven-apps/use-editable-grids#form-scripting-support
Cheers
Hi @mvdb,
To supplement on @DianaBirkelbach comments, yes it's possible as she mentioned with readonly and editable grids. but you don't necessarily need custom script to make the column readonly. You can possibly achieve it with business rules as entity scope.
Cheers
Hi @mvdb ,
You could show the views with the ReadOnly Grid.
For the Subgrids that should be editable, you could customize the EditableGrid, and write some script to disable all other columns using GridCell.setDisabled(true).
Hope this helps!
Kind regards,
Diana
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (
