Issue with date format when using UTC function

(0) Share

Report

Posted on by guinaba

Hi all,

Just wondeting what I am missing here, I've tried different combination but still keep getting the same error.

concat('Supplier Sales Report ', formatDateTime(addDays(convertFromUtc(triggerOutputs()?['body/receivedDateTime'],'AUS Eastern Standard Time'),-1),'yyyyMMdd'),'.xlsx')

InvalidTemplate. Unable to process template language expressions in action 'Create_file' inputs at line '1' and column '24868': 'The template language function 'convertFromUtc' expects its first parameter to be a string that contains a UTC date time. The value was '2021-08-29T02:43:53.0000000+00:00'. Please see https://aka.ms/logicexpressions#ConvertFromUtc for usage details.'.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

eric-cheng 5,171 on at

Like (2)

Report

Hi @guinaba ,

Try the below inside your concat()

formatDateTime(addDays(convertFromUtc(formatDateTime(triggerOutputs()?['body/receivedDateTime'], 'yyyy-MM-ddTHH:mm:ss.fffffffZ'),'AUS Eastern Standard Time'),-1),'yyyyMMdd')

I tried with the provided datetime

formatDateTime(addDays(convertFromUtc(formatDateTime('2021-08-29T02:43:53.0000000+00:00', 'yyyy-MM-ddTHH:mm:ss.fffffffZ'),'AUS Eastern Standard Time'),-1),'yyyyMMdd')

and got

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Ellis Karim 11,684 Super User 2025 Season 2 on at

Like (1)

Report

Check the <timestamp> required by the addDays function. For example, I am sending date with a format of yyyy-MM-ddThh:mm:ssZ (yyyy-MM-dd would also work):
addDays(body('Convert_time_zone'),-1)
formatDateTime(outputs('Compose'),'yyyMMddd')

Ellis

Was this reply helpful? Yes No
guinaba 6 on at

Like (0)

Report

Awesome! Thanks @eric-cheng ! It is working now!

Was this reply helpful? Yes No