Announcements
Hi,
I have a business application that has a subgrid using (Power Apps grid control). I am trying to disable a yes/no column depending on if another column is set to Closed. I tried setting up a business rule for this however it doesn't seem to trigger when the subgrid loads only after you either double click the record or you change the yes/no column. I have done some research and it looks like the Subgrid has an object called GridCell that has a method setDisabled. Documention around this object isn't great and I am hoping someone can help point me in the right direction or has developed something for this issue.
Thank you
Hi @krodgers ,
Please have a look to my blog: https://dianabirkelbach.wordpress.com/2023/07/15/disable-cells-using-power-apps-grid-customizer-control/
In the introduction I'm showing how to disable all cells of a row using onRecordSelect event.
function onGridRowSelected(eventContext) { eventContext.getEventSource().attributes.forEach(function (attr) { attr.controls.forEach(function (myField) { myField.setDisabled(true); }); }); }
And I link there another blog from @BenediktB about disabling cells for nested grids.
In your case, you would need to disable only the "yes/no" column you need.
From what I've observed, sometimes that is not fast enough.. In Power Apps Grid, sometimes the user is able to make changes before the disable logic is applied. In that case the same blog is showing another solution which is more complicated: using a Customizer Control for Power Apps Grid.
Hope this helps!
Hi @DianaBirkelbach
Thanks for this. Just wondering if you every found the time to create a generic one and uploaded it in to PCF Gallery?
Not yet.. but I'm planning to make one.
That won't help with your requirement right now 😥, since I don't have a timeline yet.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 476
WarrenBelz 365 Most Valuable Professional
Vish WR 339
