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]

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