web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / British Date/Time Form...
Power Automate
Unanswered

British Date/Time Format - Convert Date

(0) ShareShare
ReportReport
Posted on by 92

Hello,

 

Trying to convert time, whilst also re-formatting to british format (ideally after: dd/mm/yyyy - [time]), but am not having much luck.

 

Please see attached for current setup for the time conversion specifically.

 

BPPT_0-1628701315712.png

 

 

Any help would be greatly appreciated 🙂

 

Thanks,

Billy

Categories:
I have the same question (0)
  • Ellis Karim Profile Picture
    11,653 Super User 2025 Season 2 on at
    Re: British Date/Time Format - Convert Date

    Can you post the source Date/Time you are trying to convert along with the results of the Convert Time Zone action.

    What appears to be wrong with the conversion?

    Ellis

  • Ellis Karim Profile Picture
    11,653 Super User 2025 Season 2 on at
    Re: British Date/Time Format - Convert Date

    I see the issue. Please use MM (caps) for month:

    ekarim2020_0-1628704651784.png

    "11/08/2021 06:56 PM"

    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.
  • BP-PT Profile Picture
    92 on at
    Re: British Date/Time Format - Convert Date

    Thank you - much appreciated.

     

    Am I able to now set the converted time +30 mins as the end time for a calendar entry that I then want to spin-off from this?

  • Ellis Karim Profile Picture
    11,653 Super User 2025 Season 2 on at
    Re: British Date/Time Format - Convert Date

    You can try using the Add to Time action to add 30 mins

    ekarim2020_0-1628789090309.png

    Convert time:

    ekarim2020_3-1628789254401.png

    Add to time:

    ekarim2020_2-1628789172220.png

    Ellis

     

  • BP-PT Profile Picture
    92 on at
    Re: British Date/Time Format - Convert Date

    Thanks for that.

     

    Unfortunately, that's now providing me with the following error. I've also attached the settings too, to hopefully make things more clear.

     

    Thanks,

    BillyTimeZone Convert2.PNGTimeZone Convert.PNG

  • Ellis Karim Profile Picture
    11,653 Super User 2025 Season 2 on at
    Re: British Date/Time Format - Convert Date

    Try using the following Format string:

    ekarim2020_0-1628875801131.png

    as your scheduled date is in the format yyyy-MM-dd hh:mm  2021-08-12T17:23:38Z .  Format string "yyyy-MM-ddThh:mm:ssZ" will probably work too, and should give you the same results.

    Converted to 06:23 London time:

    ekarim2020_3-1628876291247.png

    06:23 add 30 mins gives 06:53:

    ekarim2020_4-1628876319764.png

    You can further format the new date and time to your needs:

    ekarim2020_5-1628876659840.png

     

    Ellis

     

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard