How to fix Start and End Date in Sharepoint List automate

Student 2023 0 Reputation points
2023-07-25T17:24:37.3566667+00:00

It seems like there might be an issue with the date and time settings in my SharePoint site or the configuration of the approval process. The timestamps provided don't appear to align correctly, with the "Starting From" date being after the "Ending" date.

Screenshot 2023-07-25 131531

This is what it looks like when you fill out the list, it shows the date and specfic time.

Screenshot 2023-07-25 132002

This is what my flow looks like. But when it is getting approved by the manager this is what they get in their email.

Screenshot 2023-07-25 132153

My question is why does the starting date and end date have these random numbers, I treid switching time zone but it still did the same thing

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

1 answer

Sort by: Most helpful
  1. Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff
    2023-07-26T06:03:31.1433333+00:00

    Hi @Student 2023 ,

    It's strange, according to your description, there is no problem with the display of time in SharePoint, and I can't reproduce your problem. From a SharePoint perspective, let's do some checks:

    1. Check whether other Lists have this problem.
    2. Check whether other sites have this problem.
    3. Check whether other accounts also have this situation.
    4. Switch browsers to try.

    For Power Automate, as Power Automate is currently not supported in the Q&A forum. Please start a new discussion via the Power Automate Community so that you can get dedicated support on this issue.


    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.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.