Unanswered

Date formatting in column

(0) Share

Report

Posted on by AntrivSingh

Hello guys, I am trying to format the dates in my CSV file as dd-mm-yyyy. By default its set to mm-dd-yyyy. The dates are being selected in a form which then presents a list and the flow is set to create a CSV file of out of said data every 2 weeks. Is it possible to format the date in the 'Enter value ' column in the flow itself? I have tried using the FormatDateTime expression and that keeps giving me errors. This is what the Select step looks like right now.

I only started using Power Automate yesterday so still trying figure my way around things.

Thanks in advance for the assistance

Categories:

Building flows

date formatting.PNG

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

trice602 15,402 Super User 2025 Season 2 on at

Like (1)

Report

Hi @AntrivSingh ,

Yes, I think you can use the expression entry there and enter formatDateTime(item()?['StartDate'],'dd-MM-yyyy'). Please mark as a solution, always glad to help! Tom

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report
@AntrivSingh
What error are you receiving? The expression should be as follows:
formatDateTime(item()?['Start date'],'dd-mm-yyyy')
Note: You will need to confirm the text between the single quotes in the expression above. The easiest way to do this is to temporarily add a Compose action with the dynamic content for the date.

It will automatically get nested into an Apply to Each action (you'll delete it anyway). Click on the three dots and select Peek Code.

Take a look at the text between the single quotes. This is what you need in your expression. Repeat this for the End date.
Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
AntrivSingh 53 on at

Like (0)

Report

Worked like a charm, much appreciated sir.

Was this reply helpful? Yes No
AntrivSingh 53 on at

Like (1)

Report

Thank you so much, works just fine

Was this reply helpful? Yes No