Convert time zone help

(0) Share

Report

Posted on by Community Power Pla...

Hello!

I got this flow that works to append comments into powersapps, but the timestamp is in the wrong timezone.

I tried to convert it with "Convert time zone" somehow but havent succeded.

Any ideas?

My flow looks like this:

Compose:

formatdatetime(items('Apply_to_each')['Modified'],'yyyy-MM-dd HH:mm')

Append to string variable:

concat('<div style="margin-bottom:5px;">',items('Apply_to_each')['Author'] 
['LookupValue'],' (<span style="color: rgb(3, 131, 
135)">',outputs('Compose'),'</span>)',': ',items('Apply_to_each') 
[variables('ColumnName')],'</div>')

I have the same question (0)

All responses (2)

Answers (1)

Jcook 7,779 Most Valuable Professional on at

Like (0)

Report

Re: Convert time zone help

Hello @Anonymous

Consider using the Convert time zone action:

Source Time zone use UTC.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (1)

Report
Re: Convert time zone help

Hi @Anonymous ,

You could convert the date time before add it to the Compose, please refer to screenshot below to create the flow:

items('Apply_to_each')['Modified']

Best regards,

Alice

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

Was this reply helpful? Yes No