Power Platform Community Forum Thread Details

Is there a way to make a specific column in an Editable SubGrid read-only in Power Apps? I have five columns total, four of which need to be editable, but one of them (specifically the first column, a lookup field) should be read-only. I’m looking for a solution that allows only that column to be non-editable without affecting the editability of the others.

Here is my current JS that filters the Editable SubGrid based on the current entity's ID, but I want to add to it to make the first column read-only:

function OnLoad(executionContext) {
    "use strict";
    var formContext = executionContext.getFormContext(); // Get Form Context
    var tabContext = formContext.ui.tabs.get("tab_a"); 

    tabContext.addTabStateChange(filterSubgrid);
    filterSubgrid(executionContext);
}

function filterSubgrid(executionContext) {
    var formContext = executionContext.getFormContext();
    var Id = formContext.data.entity.getId(); 
    var subgrid = formContext.getControl("Subgrid_S"); 

    if (subgrid) {
        var fetchXml;

        if (Id != null) {
            fetchXml = "<fetch version='1.0' mapping='logical' distinct='true'>"
                     +     "<entity name='...'>"
                     +         "<attribute name='...'/>"
                     +         "<filter type='and'>"
                     +             "<condition attribute='...' operator='eq' value='" + Id + "' uiname='' uitype='...' />"
                     +         "</filter>"
                     +     "</entity>"
                     + "</fetch>";
        }

        // Set the fetchXml to the subgrid
        subgrid.setFilterXml(fetchXml);
        subgrid.refresh();

    }
}

Categories:

Building Power Apps