Can I make only one single column editable in a view in model driven apps

[mvdb]

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

[DianaBirkelbach · Accepted solution]

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).

https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/clientapi/reference/grids/gri...

Hope this helps!

Kind regards,

Diana

[EricRegnier · Accepted solution]

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

[ekwright]

You could also keep the grid read only and use a click event to programatically edit a column.  I do this for logical cells where I just want to check or uncheck something. 

[EricRegnier]

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... 
Cheers

[Stevieed]

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

[EricRegnier]

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 🙂 

[HarryLiu]

hi.please post the code.  let me to refer to it.  thank you very much!

[Stevieed]

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