cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Janice_Lee
Helper I
Helper I

About the date/time format

Hello 👋

 

Let me show you the error details first.

Janice_Lee_0-1649383624225.png

 

What I want to do is that I will send out a mail to remind teams to review the document if they didn't sign back in 3 days after the document subbmitted. (3-day counting will skip weekend, hoildays)

Here is my flow setting.

Janice_Lee_1-1649383978134.png

Janice_Lee_2-1649384057422.png  submit date shows Janice_Lee_6-1649384141242.png

 

Janice_Lee_4-1649384087217.png

Janice_Lee_5-1649384098628.png

 

 

How should I modify to fix this issue?

Thank you.

 

Regards,

Janice

 

1 ACCEPTED SOLUTION

Accepted Solutions
fchopo
Super User
Super User

Hi @Janice_Lee 

Try to convert time to UTC using the following expression:

convertToUtc(formatDateTime(variables('the_date'),'yyyy-MM-ddThh:mm:ssZ'))

Hope it helps!

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

4 REPLIES 4
fchopo
Super User
Super User

Hi @Janice_Lee 

In the delay until action, could you try to use the following expression?:

formatDateTime(variables('the_date'),'yyyy-MM-ddThh:mm:ssZ')

Regards,

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Hello @fchopo 

 

Show you all the running raw data.

I have modified the formula you provided, but it still didn't work.

Janice_Lee_0-1649646529814.png

Janice_Lee_1-1649646548277.png

Janice_Lee_2-1649646599840.png

Janice_Lee_3-1649646613221.png

Janice_Lee_4-1649646631249.png

Janice_Lee_5-1649646639586.png

 

 

Regards,

Janice

fchopo
Super User
Super User

Hi @Janice_Lee 

Try to convert time to UTC using the following expression:

convertToUtc(formatDateTime(variables('the_date'),'yyyy-MM-ddThh:mm:ssZ'))

Hope it helps!

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Hello @fchopo ,

 

It works!!!!! 

I really appreciate 😃

 

Regards,

Janice

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,610)