Convert date time

[7eleven]

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

to get this format using UTC:

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

[v-xida-msft · Accepted solution]

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:

The flow works successfully as below:

Best regards,

Kris

[7eleven]

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

[v-xida-msft]

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

[chieffish]

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