Excellent video, and very useful! My only issue is that once the error is triggered, the mouse is placed in the first field in the list, I wonder if when the error occurs we can setFocus of the field that requires the correct entry!!
Thanks this is neat, can you also show a method to do list validation using a multiselect field? I believe this is also the issue Lea is having below, where a 'Person' field can have more than one person. I'm aware this is a lot more complex, however there is virtually no content on this on YT.
Hi Lui, I've managed to get the list validation to work. The Status column is a choice type and so is the column that I need filled in if the Status condition is met. When the condition is met, I get stuck in a glitch where my cursor will get stuck in the Status box so I'm unable to select an option for the required column. Have you had this issue before?
Unfortunately I've never experienced this issue. However I have experienced other issues when trying to implement list validation. I'd suggest clearing your browser cache, history and cookies and logging out of Microsoft 365 and then back before trying once more.
Hey, with every rule i've tried, when i test it by entering data that violates the rule, instead of displaying the error message i wrote, it shows a "Error: The server was unable to save the form at this time. Please try again." error. But the weird thing is it works correctly when editing in grid view, i only get the server error when clicking on a list item and editing via the side panel
Hi Lea, thanks for the comment. I actually noticed the same behaviour a week ago while working on my latest tutorial. I posted this on the Microsoft Tech Community and a bunch of other people have replied saying they are experiencing the same thing. No one has a solution yet unfortunately. The link is here: I'd suggest you follow that thread so you can see if anyone has an answer: techcommunity.microsoft.com/t5/sharepoint/error-quot-the-server-was-unable-to-save-the-form-at-this-time/td-p/3790816#M70204
also one of the columns i wanted to make required is a Person column and i get a "One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas." error. Do you have any tips for Person columns?
Unfortunately person type columns are not supported with column validation. To do this you would need to build a Power Automate workflow or customize your Sharepoint list form using Power Apps where you can add logic to form fields. Hope this helps and thanks
