I've read several posts about formatting time in a flow but I'm still not able to figure it out.
I saw a function like this: convertTimeZone(utcnow(),'UTC','W. Europe Standard Time','dd/MM/yyyy HH:mm')
But, where do I enter this code? Can I use it directly inline in the Flow Editor's "Start an Approval" action?
My problem is that I start a flow when a user adds an item to a SharePoint list. The SharePoint site regional settings/time zone is set to Central Time, but the email notice about the approval (from the Flow) uses a different time format. Here's an example:
I tried adding the Convert Timezone action block just before the "Start Approval" block, but how do I reference the converted time zone in the Approval block? Or does anything need to change and i just keep the approval block as-is?
Or, should I remove the Convert Timezone block, and just wrap the begindate/enddate parts of the Approval Details in the function like this?
Solved! Go to Solution.
Hi @ShawnKeeneTF,
It seems that you would like to insert the convertTimeZone function into the email body.
Please just enter the code under the Expression tab.
I have made the following test to convert the time from UTC to Pacific standard time with the following code.
convertTimeZone(triggerBody()?['RiskEventDate'],'utc','pacific standard time','dd/MM/yyyy')
Enter the code under Expression tab at the cursor position likes below:
Please feel free post back if you need more help.
Best regards,
Mabel
Hi @ShawnKeeneTF,
It seems that you would like to insert the convertTimeZone function into the email body.
Please just enter the code under the Expression tab.
I have made the following test to convert the time from UTC to Pacific standard time with the following code.
convertTimeZone(triggerBody()?['RiskEventDate'],'utc','pacific standard time','dd/MM/yyyy')
Enter the code under Expression tab at the cursor position likes below:
Please feel free post back if you need more help.
Best regards,
Mabel
Thanks!
User | Count |
---|---|
77 | |
52 | |
48 | |
27 | |
19 |
User | Count |
---|---|
28 | |
27 | |
26 | |
21 | |
20 |