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.
Why don't you use the "Convert Timezone" action? Your formula is quite complicated and will become difficult to debug in the future. I recommend preparing the date that you want to convert and then running it through the "Convert Timezone" to have an easy way to check if the conversion is done properly.
Simplicity is your friend here.
If I have answered your question, please mark your post as Solved. If you like my response, please give it a Thumbs Up. Cheers Manuel