Unanswered

How solve issue with timezone format for dubai in flow

(0) Share

Report

Posted on by MYTYwarrior

I have created a flow but getting below error please help

InvalidTemplate. Unable to process template language expressions for action 'Strategy_1' at line '1' and column '2799': 'The template language function 'convertToUtc' expects its second parameter to be a time zone matching the time zone indicated by the timestamp. The provided value '(UTC-08:00) Pacific Time (US & Canada)' is not valid or does not match the timestamp '2020-02-24T15:30:00.0000000Z'. Please see https://aka.ms/logicexpressions#ConvertToUtc for usage details.'

The value is
div(div(mul(sub(ticks(utcNow()),ticks(convertToUtc(items('Apply_to_each')?['column name'],'Arabian Standard Time'))),100),1000000000),60)

I think i have doing something wrong in arabian standard time also my entity column type is date time & behavior is userlocal.

TIA

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Satish1024 279 on at

Like (0)

Report

Have you tried 'convertTimeZone' function?
Something similar to your problem is already answered here. Check if it helps
https://powerusers.microsoft.com/t5/General-Power-Automate/Formatting-Date-And-time-in-MS-Flow/m-p/71617

Please mark it as answer if my post helps.
Thanks
Satish Reddy
https://pascalcase.com

Was this reply helpful? Yes No
MYTYwarrior 6 on at

Like (0)

Report

Thanks Satish for the replay.

still it is not working

i have tried below code

div(div(mul(sub(ticks(utcNow()),ticks(convertTimeZone(items('Apply_to_each')?['ColumnName'],'Arabian Standard Time'))),100),1000000000),60)

TIA

Was this reply helpful? Yes No
Satish1024 279 on at

Like (0)

Report

Can you tell me what exactly you are trying to do apart from timezone conversion? Are you modifying time also?

Was this reply helpful? Yes No