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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get data from a Power ...
Power Automate
Unanswered

Get data from a Power BI table and Format a date column before send a email

(1) ShareShare
ReportReport
Posted on by 111

I need to send by email a column that contains a date:

but it is coming in the following format: 2024-08-04T00:00:00
And I need it in the following format: DD/MM/YYYY

 

 

JasonCastro_0-1720824267501.png

How to formate that [DATE] column?

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,362 Super User 2025 Season 2 on at

    Hi @JasonCastro 

     

    You didn't mention exactly what format you want, but formatting is easy fortunately.

    You use the formatDateTime expression (function).

     

    I don't know if you plan on looping the records etc, but just use the formatDateTime(myvalue, "The format to do");

    To make it easy 

    Customize or format date and time values in a flow - Power Automate | Microsoft Learn

     


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard