Share via

How to fix : 2023-09-07T13:00:00Z in SharePoint/power automate

Natalya Calabina 0 Reputation points
2023-08-31T15:49:07.17+00:00

I have built a SharePoint vacation request list and I have also used power automate to generate approved or rejected emails. This is what my flow looks like: User's image

User's image

The problem is when someone gets an email the dates don't show the right time: It should say Monday, September 7, 2023 9am. Or something in those lines. User's image

And this is what my SharePoint list looks like: User's image

I'm not sure if the time zone is not right or my flow is not right

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  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

  2. Ling Zhou_MSFT 23,620 Reputation points Microsoft External Staff
    2023-09-01T05:06:05.9966667+00:00

    Hi @Natalya Calabina,

    Thank you for posting in this community.

    You can use the formatDateTime function to change the format of the date display.

    SQLCopy

    formatDateTime([Your dynamic content: start/end time], 'f')

    Here is the result in my side:

    image

    21

    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 Answers by the question author, which helps users to know the answer solved the author's problem.