Changing a date format

(0) Share

Report

Posted on by bebo987

Hi Community!

I have this little issue to fix:

I'm building a flow that fetches information from an automated email message. In this one we get a date and time in the format that follows:

however we need to plit this into DD/MM/YYY and separately HH:MM:SS.

how can i get to that result?

thank you for your help

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bebo987

Try this approach

expression :
replace(replace(replace(replace(outputs('date_and_time_to_text')?['body'],'["',''),'"]',''),'.',' '),decodeUriComponent('%27'),'')

this is to cleanup unecessary characters from the text.

expression:
formatDateTime(trim(split(outputs('Compose'),'@')?[0]),'dd/MM/yyy')

this is to obtain date in dd/MM/yyy format

expression:
formatDateTime(trim(split(outputs('Compose'),'@')?[1]),'HH:mm:ss')

Result

Hope it helps

Mark it as solution if it resolves your query !

Was this reply helpful? Yes No
bebo987 98 on at

Like (0)

Report
Copy link

Link copied!

HI @Anonymous

IT WORKS FINE ALTHOUGH THE VALUE EXTRACTED IS INSERTED INTO A SHAREPOINT LIST BUT INSTEAD OF COMING OUT AS DD/MM/YYYY COMES AS MM/DD/YYYY WHICH IS WRONG.

THE FORMULA IN POWER PLATFORM IS:
formatDAteTime(trim(split(outputs('Cleanup_date_and_time_to_text'),'@')?[0]),'dd/MM/yyy')

AND I HAVE TRIED TO CHANGE FORMAT IN SHAREPOINT HOWEVER NO SUCCESS. DO YOU HAVE ANY IDEA WHY

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bebo987

In sharepoint, I think date is stored in format of MM/dd/yyyy, that is why you got date stored as MM/dd/yyyy under datetime column.

May be use a text column and store the date there, it would preserve the dateformat as dd/MM/yyyy 🙂

Was this reply helpful? Yes No