Share via

Sharepoint list validation does not show error message if using "edit in grid view"

Li, Ruoxin 0 Reputation points
2025-08-08T07:29:39.6433333+00:00

Hi, I have a question regarding SP list validation. I've set a validation condition that if column A value is "N", then column B become mandatory and cannot be blank.

  1. Sharepoint list validation worked and show error message I set "Pls fill column B...." at the top of the form if I edit an item's column A via the form edit pane/create new item.
  2. However, my error message will not show if I edit the item via "edit in grid view". Column B can still temporarily show as "N" after I exit grid view. Only when I try to refresh the page, the page will overall display "Changes you made may not be saved" and then I can see in the refreshed page that Column A is indeed not changed to "N" as column B is still blank.

However I find mode 2 is not intuitive for my users who prefer using "edit in grid view mode" as they will not see the guidance error message I want them to see, to make the proper update needed. They may not even know that their choice is not saved after refreshing if they don't take a 2nd look.

Is there any better solution to this inconvenience? Thanks a lot!

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Henry-N 855 Reputation points Microsoft External Staff Moderator
    2025-08-08T11:17:49.14+00:00

    Hi @Li, Ruoxin, 

    Thanks for posting your question in the Microsoft Q&A forum. 

    To better assist you with the issue that the SharePoint list validation does not show error message if using "edit in grid view", I’d like to ask a few quick questions to better understand your situation: 

    Have you tried creating a new list using the same validation formula to see if the issue still occurs? 

    Could you please share the formula you're using and the columns involved (feel free to redact any private information)? This will help me try to reproduce the issue on my end. 

    If possible, could you provide a screenshot of the issue and specify the column types you're working with? 

    I’ve tested this formula on my end, and the validation error does appear in "Edit in grid view." To help troubleshoot further, I’ll need more details from your setup so I can try to replicate the issue accurately.User's image

    User's image

    Once again I'm sincerely sorry for the inconvenience that you've encountered. But I need to know more about your situation so I can help you better. I appreciate your patience and are here to help. Looking forward to your response 

    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.  User's image

    0 comments

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.