SharePoint online JSON form: in case of validation settings failure, scroll up not working

RogerVISSIO-8962 25 Reputation points
2023-11-22T17:01:36.18+00:00

Hello,

On my SharePoint online list, I have created a custom JSON form using Edit columns and configure layout. In the list settings, under Validation settings, I have configured a rule to check some dates (basically, start date should be before end date). If a user enters an incorrect date combination, the form cannot be saved, which is what I want. However, the issue is that it is no longer possible to scroll up to correct the date. The form is behaving strangely, I can see that the cursor is navigating through the input fields of the form, the date calendar opens. Then form becomes normal after waiting for a couple of minutes.

Any idea on how I can fix this?

I tried many options, like moving the date fields at the top of the form, making the validation error message shorter, in JSON layout, changed the column names to internal names, no luck.

Regards,

Microsoft 365 and Office SharePoint For business Windows
0 comments No comments
{count} votes

Accepted answer
  1. AllenXu-MSFT 24,941 Reputation points Moderator
    2023-11-29T08:12:32.92+00:00

    Hi @RogerVISSIO-8962,

    Thanks for your cooperation and active response!

    This is obviously not a common issue, and we couldn't reproduce this issue on our ends. To reduce the negative impact on your business and resolve this issue ASAP, it's recommended to open a ticket with Microsoft via going to M365 admin center >> Support >> New a service request. MS experts can have a remote session with you, collect logs and help you check from the backend. Thanks for your understanding:)


    If the answer is helpful, please click "Accept as 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.


2 additional answers

Sort by: Most helpful
  1. AllenXu-MSFT 24,941 Reputation points Moderator
    2023-11-23T07:22:27.6266667+00:00

    Hi @RogerVISSIO-8962,

    I couldn't reproduce this issue on my site. I created a list with coulmn "Start Date" and "End date" and applied the validation formula [Start Date]<[End date]. But I still can correct the date columns after the validation triggers.

    Could you try it in another browser or in another device?


    If the answer is helpful, please click "Accept as 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.


  2. RogerVISSIO-8962 25 Reputation points
    2023-11-29T07:54:54.19+00:00

    Hello,

    There is no Power Apps form, it is a SharePoint online form customized with JSON (header, body and footer, with additional conditional formulas on some fields). Attached is an animation showing the strange behavior.

    StrangeScreenBehavior


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.