Answered

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

(0) Share

Report

Posted on by 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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Verified answer

Diana Birkelbach 3,072 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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/gridcell

Hope this helps!

Kind regards,

Diana

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ekwright 4 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
steeevid 333 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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 🙂

Was this reply helpful? Yes No
HarryLiu 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
steeevid 333 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No