Forum Discussion

akinlaw's avatar
akinlaw
Copper Contributor
Jul 17, 2024

Sharepoint List Validation

I have a status column in a SharePoint list. I need to write validation to make sure the statuses go in order. The correct order for all entries should be " not started" -> " In Work" -> "Complete". I also want to make it so that if the list item is a "Material Site transfer" to "XYZ city" it will allow you to choose " in transit" so the order would be " not started" -> " In Work" -> " in transit" ->"Complete" but only if the Request type = material site transfer and To location = XYZ city. Any help would be appreciated, Im not savvy with coding.

Lists
microsoft lists
sharepoint embedded

1 Reply

Sort By
  • michalkornet's avatar
    michalkornet
    Iron Contributor
    Jul 20, 2024

    Hi akinlaw, The order of the states would not be possible to enforce with just the List Validation functionality. What about using a Power Apps form or Power Automate for this purpose?

     

    Maybe you can try combining some features:

    - List Validation: To ensure that the required fields are filled out per status.
    - Power Automate flow: For example, using the "For a selected item" trigger to ensure that the order of the statuses is correct.

Resources