Unanswered

Convert yyyy-MM-dd to dd-MM-yyyy in Flow

(0) Share

Report

Posted on by TORFS_BE

I tried to google a bit and a couple of suggestions later I cannot get this to work.

I have to say my knowledge of Microsoft Flow isn't wide enough to fully understand all things being said in these topics.

Whenever I adjust something in my current Flow, it doesn't work anymore untill I change it back to how it was.

Ok here we go;

My Flow basically does

1. Get item out of a Sharepoint List I created which has a column date named "Startdatum"

2. Convert time zone is what im using right now but this should be adjusted

3. The Filter Array is basically my reminders being setup to because the next step (4)

4. I send out a message in TEAMS based on timestamps (1 or 7 days notice) based on the date in the sharepoint list

convert timezone detail:

This is how my current message looks like in TEAMS;

Most ideal would be to have the timestamp being messaged dd-MM-yyyy.

All suggestions say I should be using "formatDateTime" but I have no idea where to change or add this to make it all working...

(I tried to add it under the format string in the "Convert Time Zone" but when I do that, no messages are being send out to TEAMS anymore)

Thanks!!!

Categories:

Using flows

All responses (9)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TORFS_BE ,

Please use this expression where you need to insert the time.

formatDateTime(body('Convert_time_zone'),'dd-MM-yyyy')

Best regards,

Rimmon
TORFS_BE on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft

Sorry it's probably just me but it's not working for me.
I probably did it wrong.

What I want to achieve is basically my timestamps that im mapping in the message
"startdatum" and "einddatum" to be in the format (he takes data from sharepoint)
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TORFS_BE ,

You just need to replace 'body('Convert_time_zone')' with "startdatum" dynamic content.

formatDateTime(body('Convert_time_zone'),'dd-MM-yyyy')

Step1.Delete 'body('Convert_time_zone')'.

Step2.Select the dynamic content where 'body('Convert_time_zone')' was deleted, and the relevant expression will appear.

Above is also for "einddatum" dynamic content.

Best regards,

Rimmon
TORFS_BE on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft

Thanks for the quick reply.
I think I understand you now, apologies.

Beow you can see what I adjust.
However, my flow runs without any problems... but the messages won't pop up anymore in TEAMS now.
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TORFS_BE ,

It should be 'item()?['startdatum']' not 'startdatum', please modify your expression.

formatDateTime(item()?['startdatum'],'dd-MM-yyyy')

Best regards,

Rimmon
TORFS_BE on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft

Sorry, thanks for the adjustment!
I changed as you mentioned, but nothing pops up in TEAMS. The flow ran without errors tho.

I know if I convert it back to the old format, the messages will pop up in TEAMS.
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TORFS_BE ,

Did the send message action fail in your test? If so, provide a screenshot of the error.

Best regards,

Rimmon
TORFS_BE on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft

Did not fail during test, all green lights... yet no message in TEAMS
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TORFS_BE ,

I don't think the problem has anything to do with the expression because your flow is not failing. Maybe we're missing something.

Please click the "Filter array" and "Send message" after they run and provide screenshots about the results.

By the way, have you tried to create another flow with "Get items" and "Send message" to test the provided expression?

Best regards,

Rimmon