cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
clubinski
Helper III
Helper III

Convert Date and Times for Dynamics 365

Good afternoon all,

 

working with a generic template from the Power Automate store for a "Daily email with Activities from Dynamics 365 Due Today"

 

 

The time in the template is set to UTC using a filter query and i would like to convert the date and time from UTC to our local time zone of EST and show MM/DD/YYYY HH:MM

 

The filter query has the functions below  for the Start and Due date fields from the activity entity

 

Start Date:

formatDateTime(utcNow(),'yyyy-MM-dd')

 

Due date : 

formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')

 

Flow.png

 

 

 

This what the report looks like without the conversion

emailreport.png

 

 

Please advise,

 

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @clubinski ,

 

Could you share the specific configuration in Apply to each?

 

I have no way to get the template you are using, so I don't know its specific configuration.

 

Regarding the time zone conversion, you could consider using the Convert time zone action to convert the time zone, and then configure the Format string to specify the time format.

 

Then append the value of the Convert time zone action to the array variables.

 

Best Regards,

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

View solution in original post

4 REPLIES 4
v-bacao-msft
Community Support
Community Support

 

Hi @clubinski ,

 

Could you share the specific configuration in Apply to each?

 

I have no way to get the template you are using, so I don't know its specific configuration.

 

Regarding the time zone conversion, you could consider using the Convert time zone action to convert the time zone, and then configure the Format string to specify the time format.

 

Then append the value of the Convert time zone action to the array variables.

 

Best Regards,

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

View solution in original post

Hey @v-bacao-msft ,

 

Apply to Each Configuration:

 I use this to pull the account names

Apply to Each ConfigApply to Each Config

 

 

 

I tried using the Convert Time zone action before the array, during and after and nothing works. I DIDNT however format string differently if that was needed.

 

 

Attempted Configuration

Atempted ConfigurationAtempted Configuration

 

Convert Time Zone Config

Converted Time Action ConfigConverted Time Action Config

 

Error Received when running

Convert Time Zone ErrorConvert Time Zone Error

 

 

I do not see the ISO 8601 format as an option under the convert time zone action.

 

 

Hope this helps!

@v-bacao-msft 

 

I tried this as your suggestion, did I miss understand your suggestion?

 

 

Attempt2.png

 

I received the same error as in my previous post.

 

 

Please advise,

 

Thank you

You can only due one field per converted time action.

 

 

That was my problem. I was trying to do but Due Date and Start in one converted time which will not work. Separated it out and all worked perfectly.

 

Thank you

 

@v-bacao-msft 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,619)