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
Solved! Go to Solution.
Please use this one only-
Variable - SerialDateTime , type -float.
Expression used-
output-
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 Okay do one thing. In one compose take Time value and then in set variable pass float(Output('compose')).
Check now.
Thanks
Hardesh
you can use
But how and where add this? I'm still learning building flows so that would mean much to me.
Hi Rahber
I figured out how and where add it, but i have problem and message:
Do you know how to fix it?
@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
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.
@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 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 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 simply pass excel column Time EST/EDT from dynamic content tab. Do not use any expression.
Thanks
Hardesh
@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 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
@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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
40 | |
18 | |
15 | |
14 | |
13 |
User | Count |
---|---|
67 | |
36 | |
28 | |
21 | |
19 |