Unanswered

Help with data format

(0) Share

Report

Posted on by Community Power Pla...

I have a SharePoint list where I have some dates, I'm making a flow to read this SharePoint list and send an email with all the dates, but a need to that these dates be in the format like this (dd/MM/yyyy) but they are in this format (MM/dd/yyyy)

Any suggestions?

thanks for the help

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous you have 2 options; either you can use a formatDateTime expression or there is a the Convert Time Zone action which I use regualrly to convert to dd/MM/yyyy format.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @RobElliott thanks for your help, I have been trying to use formatdatetime expression with no success, always give me an error, do you have any suggestion?

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous, your image doesn't give me any clue as to where you are adding the formatDateTime expression - there's no Compose action in your screenshot - so I can't even see where you are getting an error. Where are you doing the formatDateTime?

Rob
Los Gallardos

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report
Hi @Anonymous ，

Please refer to screenshot below to add expression to the Create html table action and let me know if your problem could be solved:

formatDateTime(item()?['Created'],'dd/MM/yyyy')

Best regards,

Alice

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for all the help guys,

I still have the error.
I have tried the Alice solution:

This was the error message:

Thanks so much

Was this reply helpful? Yes No