About the behavior of sharepoint list Verification settings

Question

About the behavior of sharepoint list Verification settings

masaaki namba 0

【Question】

Hello all,

I have a question about lists of sharepoint.

I made a input form in lists of sharepoint.

I confirmed that when I enter a form and save it, the behavior occurs as if items are randomly selected for a certain period of time.

I send the movie.Could you check my movie?

Is there any way to avoid this? If there is, I would appreciate your cooperation.

【Condition】

・Change the main text of the layout structure,

・Add formulas and error messages in Verification settings.

・Enter the content that will be an error in the verification settings in the form.

Below are the details of the settings.

(Verification settings)

・Formula : =EndTime>StartTime

・User Message : The confirmation time period is incorrect.

(Configure layout - Apply formatting to Body - Formatting code)

{ 

"sections": [ 
{ 

    "displayname": "Confirmation Time", 

    "fields": [ 

        "Title", 

        "StartTime", 

        "EndTime" 

    ] 

}, 

{ 

    "displayname": "Input1", 

    "fields": [ 

        "Item1", 

        "Item2", 

        "Item3" 

    ] 

}, 

{ 

    "displayname": "Input2", 

    "fields": [ 

        "Item4", 

        "Item5" 

    ] 

}, 

{ 

    "displayname": "Others", 

    "fields": [ 

        "Item6", 

        "Item7" 

    ] 

   }
 ] 

}

【Environment】

Windows 10 Enterprise(64bit)、ver.：21H2

Animation_en

2 answers

Your answer

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 2

Emily Du-MSFT 51,836 Microsoft External Staff

Have you added other JSON codes in this list? Whether you use Power Apps to customize the list?

Try to create a brand-new list, then add Body JSON codes and list validation, check this issue whether occurs.

Clear the browser cache or go to other browsers to check this issue whether occurs.

Here is my test result:

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.

masaaki namba 0 Reputation points

2023-09-07T02:09:21.68+00:00

Thank you for your reply.

I don't use Power Apps.

I checked the browser cache or other browsers.

Sorry, could you try again with the following content?

・StartTime：9/27/2023

・EndTime：9/6/2023

Please enter the content that will be an error in the verification settings in the form.

This is a simplified version of the system my colleagues use at work.

Since this is a system for users, I would like to check the behavior when unintended data is entered.
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2023-09-07T02:46:00.88+00:00

Yes, I could. Here is the new test result.
masaaki namba 0 Reputation points

2023-09-07T07:27:04.5033333+00:00

Thank you for your reply.

This happens in my environment.

Could you check our environment and setting?

I sent the movie again.

I sent captures of my environment.

※Sorry japanese notations are included.

Below is my environment.

【Environment】

Windows：Windows 10 Pro(64bit)、version：22H2

Office365：Office 365 E5

Internet Edge：116.0.1938.69

Google Chrome：116.0.5845.180

There is one thing that bothered me.

My form has no calendar icon.

On the other hand, Emily-san's form has a calendar icon.

Please check "Emily-san_list.PNG" and "namba_list.PNG".

Is this irrelevant?

Emily-san_list.PNG

namba_list.PNG

sharepoint_license_1.PNG

sharepoint_license_2.PNG

Windows_version.PNG

GoogleChrome_version.PNG

InternetEdge_version.PNG
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2023-09-07T07:50:33.7966667+00:00

By default, the date and time filed has calendar icon.

JSON formatting and list validation are some basic settings. They work in the browser, so I don't think the Windows System is the cause. Office 365 E5 is also enough. (My account license is Office 365 E3). I have tested in the Google Chrome with Version 109.0.5414.149 (Official Build) (64-bit) and Edge with Version 116.0.1938.69 (Official build) (64-bit).

And I want to confirm some information.

1.Whether only you or all users has this issue?

2.Try to create a brand-new list, then add Body JSON codes and list validation, check this issue whether occurs.
masaaki namba 0 Reputation points

2023-09-07T09:27:01.16+00:00

1.Whether only you or all users has this issue?

→It's not only me.

　When my colleague created same list, he also confirmed the same phenomenon.

2.Try to create a brand-new list, then add Body JSON codes and list validation, check this issue whether occurs.

→I tried to create a brand-new list and add Body JSON codes, but this issue occurred.

※Sorry I took a movie, but I couldn't send it because it was too large.
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2023-09-07T09:35:01.59+00:00

Another question, you use Microsoft List or a list in the SharePoint site collection?

If you use a list in the SharePoint site collection, I suggest you test in another site collection.

In addition, check the network, it may be a cause.
masaaki namba 0 Reputation points

2023-09-08T08:44:48.94+00:00

Sorry, I posted it twice by mistake.

I'll edit the first post.
masaaki namba 0 Reputation points

2023-09-08T08:46:22.97+00:00

Another question, you use Microsoft List or a list in the SharePoint site collection?

If you use a list in the SharePoint site collection, I suggest you test in another site collection.

→I use a list in the SharePoint site collection.

　I created a site using the following steps.

　　Home of Sharepoint→Create site→Team site

　Similarly I tried the test in Microsoft List.

　I confirmed the same phenomenon again.

　I sent the movie again.

In addition, check the network, it may be a cause.

→I think it is irrelevant.

　I tried the test in other PC and other tenant.

　I confirmed recall rate is 100%.

　Office365 license of other PC is "Office 365 E5".

I have a question.

Could you confirm test with the following content?

・Item6：change from "Person or Group" to "Date and Time"

・Item7：change from "Person or Group" to "Date and Time"
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2023-09-08T10:05:01.0066667+00:00

Here is my test result.

In my opinion, this issue is mostly caused by SharePoint backstage. The most effective way is to go to Microsoft admin center -> Support -> Open a service request with Microsoft to report and solve this issue.
masaaki namba 0 Reputation points

2023-09-11T06:34:33.7866667+00:00

Thank you for your test and reply.

Sorry, could you tell me the link for "Microsoft admin center"?

I investigated but couldn't find it.
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2023-09-11T06:39:57.5166667+00:00

Here is the link: https://admin.microsoft.com/.

You should access the link with admin account.
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2023-09-19T08:27:07.08+00:00

How are the things going on about this issue?

I am looking forward to your feedback if there is any update.
masaaki namba 0 Reputation points

2023-09-20T07:54:21.7866667+00:00

Sorry for my late reply.

I could not entry your link: https://admin.microsoft.com/.

So I am contacting our MicroSoft administrator how I can open a service request with Microsoft.
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2023-09-22T01:47:53.3333333+00:00

Thanks for your reply.

Please remember to update this thread if you have any progress.

Share via

About the behavior of sharepoint list Verification settings

2 answers

Your answer