cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
7eleven
Frequent Visitor

Convert date time

i try to convert 'Compose 15' and Compose 20'

Capture d’écran 2017-10-29 à 14.51.35.png

Capture d’écran 2017-10-29 à 14.51.49.png

 

to get this format using UTC:

 

 2017-10-30T09:00-00:00

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @7eleven,

 

I have made a test on my side and please take a try with the following workaround:

  • Add a proper trigger, here I use Flow button trigger.
  • Add “Compose” action, Input set to 30/10/2017
  • Add “Compose 2” action, Input set to 10:00.
  • Add “Initialize variable” action, Name set to Date, Type set to Array, Value set to the following formula:

 

split(outputs('Compose'),'/')

 

  • Add “Compose 3” action, Input set to the following formula:
concat(variables('Date')?[2],'-',variables('Date')?[1],'-',variables('Date')?[0],'T',outputs('Compose_2'),'-00:00')

 

Image reference:6.JPG

 

The flow works successfully as below:7.JPG

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-xida-msft
Community Support
Community Support

Hi @7eleven,

 

I have made a test on my side and please take a try with the following workaround:

  • Add a proper trigger, here I use Flow button trigger.
  • Add “Compose” action, Input set to 30/10/2017
  • Add “Compose 2” action, Input set to 10:00.
  • Add “Initialize variable” action, Name set to Date, Type set to Array, Value set to the following formula:

 

split(outputs('Compose'),'/')

 

  • Add “Compose 3” action, Input set to the following formula:
concat(variables('Date')?[2],'-',variables('Date')?[1],'-',variables('Date')?[0],'T',outputs('Compose_2'),'-00:00')

 

Image reference:6.JPG

 

The flow works successfully as below:7.JPG

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your answer ! So i have to change to change the time manually ?

Hi @7eleven,

 

The value you provided is not a string timestamp, we could not use Date function to convert it in Microsoft Flow currently.

 

More details about Date functions, please check the following document:

Date functions

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you so much, I would have been trying to work this out all night if i didnt find your post 🙂

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (5,476)