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

Dateformat Dynamic Content field

Hi there,

I have created a flow for a SharePoint list which is using PowerApps to present the form to the users. The flow sends an email when the form for a employee that is leaving the company is filled in. The email has a Dynamic Content field called 'Date of offboarding'. This field in the form shows the date as for example 25-04-2019. But when the email is send the email shows the date as 04-25-2019.

How can I get the email to show the date as 25-04-2019 (DD-MM-YYYY)?

Thanks and regards.

datumuitdienst.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
RobElliott
Super User
Super User

1. Add a Date Time Control and select Convert time zone as the action.

2. Select the SharePoint column with the date in it and in the next box select the base time which will be UTC. Then select your timezone and in the last box enter the date format you want as a Custom date.

3. In your email, in Dynamic content select Converted time.

4. The result will be in the format you want:

dateTimeControl.jpg

 

 



 

 

 

 

 

convertTimeZone2.jpg

T

 

 

 

 

convertedTime.jpg

 

 

 

 

 

 

convertedTimeResult.jpg

 

 

 

There are other ways of doing it using a formatdatetime expression, but since Microsoft released the Convert Time

Zone action it's much easier.

Rob
Los Gallardos

View solution in original post

2 REPLIES 2
RobElliott
Super User
Super User

1. Add a Date Time Control and select Convert time zone as the action.

2. Select the SharePoint column with the date in it and in the next box select the base time which will be UTC. Then select your timezone and in the last box enter the date format you want as a Custom date.

3. In your email, in Dynamic content select Converted time.

4. The result will be in the format you want:

dateTimeControl.jpg

 

 



 

 

 

 

 

convertTimeZone2.jpg

T

 

 

 

 

convertedTime.jpg

 

 

 

 

 

 

convertedTimeResult.jpg

 

 

 

There are other ways of doing it using a formatdatetime expression, but since Microsoft released the Convert Time

Zone action it's much easier.

Rob
Los Gallardos

Hi @RobElliott ,

That is great. I have tried it and it works perfectly.

Thank you very much.

Regards Ewoud

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,061)