How to set a choice column values base on the selection of another choice column? In sharepoint list

Question

How to set a choice column values base on the selection of another choice column? In sharepoint list

Mumtaz Sharif (US) 0

In a sharepoint list, I have a choice column "Current status" with options- "A", "B", "C". I have another choice column in the same list "Next step". I want the option of this second column "Next step" based on the selection of the "Current status" . If "Current status" is "A", then options in drop down of "Next step" should be- "X", "Y", "Z", If "Current status" is "B", then options in drop down of "Next step" should be- "P", "Q", "R", and If "Current status" is "C", then options in drop down of "Next step" should be- "G", "H", "K". write sharepoint list logic for this

Ling Zhou_MSFT 23,620 Reputation points Microsoft External Staff

2023-12-25T02:53:42.85+00:00

Thank you for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.

Claire James John 0

Create a SharePoint list with "Current Status" (Choice: A, B, C) and "Next Step" (Choice: X, Y, Z, P, Q, R, G, H, K) columns.

Add JavaScript code using a Script Editor or Content Editor Web Part to dynamically show/hide "Next Step" options based on the selected "Current Status."

$(document).ready(function () {
    $("select[title='Next Step']").find("option").hide();

    $("select[title='Current Status']").change(function () {
        var currentStatus = $(this).val();
        $("select[title='Next Step']").find("option").hide();

        // Show options based on "Current Status"
        switch (currentStatus) {
            case "A": $("select[title='Next Step']").find("option[value='X'], option[value='Y'], option[value='Z']").show(); break;
            case "B": $("select[title='Next Step']").find("option[value='P'], option[value='Q'], option[value='R']").show(); break;
            case "C": $("select[title='Next Step']").find("option[value='G'], option[value='H'], option[value='K']").show(); break;
        }
    });
});

Save the changes to the list form and test the functionality to ensure proper visibility of "Next Step" options according to the selected "Current Status."

Consider using Power Automate to automate this logic based on triggers like item creation or modification.

Thoroughly test in a development environment before implementing changes in the production environment.

1 answer

Your answer

Ling Zhou_MSFT 23,620 Reputation points Microsoft External Staff

2023-12-25T02:53:42.85+00:00

Thank you for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.
Claire James John 0 Reputation points

2023-12-25T06:59:24.25+00:00

Create a SharePoint list with "Current Status" (Choice: A, B, C) and "Next Step" (Choice: X, Y, Z, P, Q, R, G, H, K) columns.

Add JavaScript code using a Script Editor or Content Editor Web Part to dynamically show/hide "Next Step" options based on the selected "Current Status."

$(document).ready(function () { $("select[title='Next Step']").find("option").hide(); $("select[title='Current Status']").change(function () { var currentStatus = $(this).val(); $("select[title='Next Step']").find("option").hide(); // Show options based on "Current Status" switch (currentStatus) { case "A": $("select[title='Next Step']").find("option[value='X'], option[value='Y'], option[value='Z']").show(); break; case "B": $("select[title='Next Step']").find("option[value='P'], option[value='Q'], option[value='R']").show(); break; case "C": $("select[title='Next Step']").find("option[value='G'], option[value='H'], option[value='K']").show(); break; } }); });

Save the changes to the list form and test the functionality to ensure proper visibility of "Next Step" options according to the selected "Current Status."

Consider using Power Automate to automate this logic based on triggers like item creation or modification.

Thoroughly test in a development environment before implementing changes in the production environment.

Answer 1

Ling Zhou_MSFT 23,620 Microsoft External Staff

Hi @Mumtaz Sharif (US),

Thank you for posting in this community.

We can use PowerApps to create cascading columns in SharePoint Lists.

You can refer this article to create it: Working with Cascading Lists in SharePoint and Power Apps.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Mumtaz Sharif (US) 0 Reputation points

2023-12-25T07:27:39.2566667+00:00

We can’t use powerapps, we need to perform this on sharepoint list only.
Mumtaz Sharif (US) 0 Reputation points

2023-12-25T07:28:24.81+00:00

Can’t use powerapps, need solution for sharepoint list only
Ling Zhou_MSFT 23,620 Reputation points Microsoft External Staff

2023-12-25T08:30:13.62+00:00

Hi @Mumtaz Sharif (US),

Thank you for your reply.

We apologize that there is no out-of-the-box way to create conditional selection columns at this time. PowerApps is the best way to accomplish this.

Please accept my sincerely apologize for any inconvenience this may cause. Thank you for your kind understanding.

Share via

How to set a choice column values base on the selection of another choice column? In sharepoint list

1 answer

Your answer