Disable an editable field in the Power Apps Grid Control feature.

(0) Share

Report

Posted on by AMD99

105

I'm currently using the out of the box 'Power Apps Grid Control' pcf on a subgrid to display child records. This is ideal as I need to show option set colours and allow the users to edit the data inline.

I have the 'editable' option set to 'Yes' but there is one field in the subgrid I want to prevent users from editing.

I have tried numerous methods mentioned online including using a 'business rule' and javascript.

However, none of these methods seems to be affecting it and I'm wondering if these would traditionally be used with the 'Editable Grid' control as opposed to the 'Power Apps Grid Control'.

Has anyone come across this before and can they advise how this can be done? There is also a chance I could be implementing these changes incorrectly and they work fine for others?

I have the same question (0)

All responses (5)

Answers (1)

Community Member on at

Like (0)

Report

cool

Was this reply helpful? Yes No
Leco Lv on at

Like (1)

Report

Hi partner,

I think Js should be able to do it (setDisabled ), can you provide your code?

GridCell (Client API reference) in model-driven apps - Power Apps | Microsoft Learn

Was this reply helpful? Yes No
AMD99 105 on at

Like (0)

Report

Hi, below is the code I'm using, triggered when a record is selected in the subgrid UI.

function fnLockFields(executionContext) {

let oFormContext = executionContext.getFormContext();

if (oFormContext) {

let arrFields = ["new_currentstatus"];

let objEntity = oFormContext.data.entity;

objEntity.attributes.forEach(function (attribute, i) {

if (arrFields.indexOf(attribute.getName()) > -1) {

let attributeToDisable = attribute.controls.get(0);

attributeToDisable.setDisabled(true);

}

}

)};

}

Was this reply helpful? Yes No
AMD99 105 on at

Like (0)

Report

I just tested my code on the regular 'Editable Grid' control and it works. But does not work with the 'Power Apps Grid Control'

Was this reply helpful? Yes No
Verified answer

Leco Lv on at

Like (0)

Report

Hi partner,

I noticed that this is a preview function, and maybe only the following two types are currently supported.

Power Apps grid control(preview): learn.microsoft.com/.../the-power-apps-grid-control

Was this reply helpful? Yes No