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

Mumtaz Sharif (US) 0 Reputation points
2023-12-22T10:10:43.0833333+00:00

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

Microsoft 365 and Office | SharePoint | Development
Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft Copilot | Microsoft 365 Copilot | Development
Microsoft Security | Microsoft Graph
{count} votes

1 answer

Sort by: Most helpful
  1. Ling Zhou_MSFT 23,620 Reputation points Microsoft External Staff
    2023-12-25T05:48:06.7433333+00:00

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.