Skip to main content

Notifications

Customer Service forum
Suggested answer

Remove Optionset from a column in Editable subgrid

Posted on by 10

Hello , 
I have requirement to remove options from optionset on click of a record through JS . 
Example I have a column "Status" whose values are A , B  ,C , D .
On select of a record I would like to show only A & B in the editable grid.

  • Ray Profile Picture
    Ray 1,490 on at
    RE: Remove Optionset from a column in Editable subgrid

    Accoding to my research, this is not a doable requirement.

    There are fewer methods/events you can access in grid control, compare with formContext control. You can see detail with GridAttribute.

    Also here is my test result:

    "executionContext" is the gridContext. "new_source" is an optionset field but it does not have the removeOption() method.

    function onRowSelected(executionContext){
        debugger;
        executionContext.getFormContext().data.entity.attributes.forEach(attribute => {
            if(attribute.getName() == 'new_source'){
                attribute.controls.get(0).removeOption(100000001);
            }
        });
    }

    WeChat-Screenshot_5F00_20220808135358.png

    Also you can read more about Grid.

  • Ray Profile Picture
    Ray 1,490 on at
    RE: Remove Optionset from a column in Editable subgrid

    The gridContext is different with the formContext. If you are trying to access some control/attribute in grid, you should use gridContext rather than formContext.

  • Medidhi Profile Picture
    Medidhi 10 on at
    RE: Remove Optionset from a column in Editable subgrid

    Thanks for your reply .I have tried  this  , its not working in case of Editable Subgrid .

    pastedimage1657280579352v1.png

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,962 Super User 2024 Season 1 on at
    RE: Remove Optionset from a column in Editable subgrid

    Hi,

    Please try Remove option code to remove option from your field

    docs.microsoft.com/.../removeoption

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.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans