date and time

[Tofifi]

Hello

I created a flow which takes rows with date and time from excel sheet and sends mail to user. Unfortunately i get message like this:

2021-03-10T00:00:00.000Z at 1899-12-30T09:30:00.000Z

but i want this:

2021-03-10 at 09:30:00

Does anyone knows how to do it?

Thanks

[Rahber]

you can use

formatDateTime(yourdatevariable,'yyyy-MM-dd') and 

formatDateTime(yourtimevariable,'HH:mm:ss')

Make sure to update the variable for your date and time in the above

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,
Rahber

To acehive your need

[Tofifi]

But how and where add this? I'm still learning building flows so that would mean much to me.

[Tofifi]

Hi Rahber

I figured out how and where add it, but i have problem and message: 

Do you know how to fix it?

[Hardesh15]

@Tofifi Pls share your flow screen.

For date serial number (in Compose action i am passing excel date). Pls use following expression-

addDays('1899-12-30',int(outputs('Compose')),'dd-MM-yyyy')

Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
Regards,
Hardesh

[Tofifi]

Hi @Hardesh15

Fortunately i figured out how to fix the date issue but thank you for your reply. Now i have the same problem with time:

time i have in different column.

[Hardesh15]

@Tofifi Pls share your flow screen not running instance. i want to check your expression for date and time.

Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
Regards,
Hardesh

[Tofifi]

@Hardesh15 
That's how it looks:

[Tofifi]

@Hardesh15 

Sorry i forgot to put formula, here it is:

[Hardesh15]

@Tofifi pls check if your date column has null value. If it is null value then use condition isblank(column name) in format date time expression.

Thanks

Hardesh

[Tofifi]

@Hardesh15  

No, it doesn't have null value:

I don't have problem with date anymore but with time.

[Hardesh15]

@Tofifi  pls use one compose action and pass your excel time column so that i get to know what kind of data is coming from excel.

Thanks

Hardesh

[Tofifi]

@Hardesh15 

i used compose and still got error:

How do you want me to pass time column?

[Hardesh15]

@Tofifi  simply pass excel column Time EST/EDT  from dynamic content tab. Do not use any expression.

Thanks

Hardesh

[Tofifi]

@Hardesh15 
This is the result:

[Hardesh15]

@Tofifi  it means that int function is rounding of time as zero so null value error is coming. Fetching time from excel is little bit complex. I will share screens after sometime.

Thanks

Hardesh

[Tofifi]

@Hardesh15 

I will wait for the results.

Thank You!!

[Hardesh15]

@Tofifi Please follow step by step. ( i have hard coded substring index but it will work)

Output-

i did not make calculation for seconds so concatenate in last as 00.

Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
Regards,
Hardesh

[Hardesh15]

@Tofifi  if you face out of index error change 10 to 5. Unfortunately logic is working for 10+ hour time. i will fix and give you new solution.

Thanks

Hardesh

[Tofifi]

Thank you @Hardesh15  for your effort! I will try this out.