Forum Discussion
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". ...
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.