Forum Discussion

GeorgieBu's avatar
GeorgieBu
Copper Contributor
Jun 16, 2023

Limiting Maximum number of Choices in List

Hi, 

 

I have a Column in a SharePoint List for 'Reason customer cancelled Order'. 

My Choice column has a pre-set number of options (around 10) which detail reasons why customers might cancel. (E.g. 'Product not available in the right colour', 'Long delivery times', 'Bought from competitor').

I want to limit the number of maximum choices someone can pick using Column Validation to 3 choices max. (E.g. Someone can then tag the order being cancelled for the reasons of 'Long delivery times' & 'Bought from competitor'). 

I don't want to create three different Choice columns each maxed at 1 choice entry as this is not compatible for a good user experience when inputting data into the List. 

 

Any help would be appreciated if anyone knows what the correct code for validation would be! 

Column Validation
json
Lists
    • GeorgieBu's avatar
      GeorgieBu
      Copper Contributor
      Jun 16, 2023

      DaveMehr365 

      I understand PowerApps would be able to offer much more flexibility, but in this instance, we are looking to complete as much as possible within just SharePoint / Lists. I was hoping their would be a sort of MAX function that could be easily coded.

      • RobElliott's avatar
        RobElliott
        Silver Contributor
        Jun 16, 2023

        GeorgieBu  it can also be sone in Microsoft Forms if you send the customer a survey. Forms has the ability to limit the number of choice options selected.

         

        Rob
        Los Gallardos
        Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources