We need to convert check-in time (date&time) with AM Or PM, to fill date and time column in a SharePoint list
Please find the below screenshot to check the time output
check answer 4
Solved! Go to Solution.
use the below expression to convert it to dateTime
addSeconds(‘1970-1-1’, add(div(int(triggerBody()?[‘answer4’]),1000), 19800), ‘yyyy-MM-dd hh:mm tt’)
kindly change the highlighted value with your corresponding timeZone seconds like india is ahead by 5:30hr so I added 19800
Hi @makpith
Use following expression to get time in AM/PM format(12 hr pattern)
Hi, I've done what you have suggested but it didn't work, please find attached file below:
So the Answer that comes directly from kaizala is as the attached file, which is something that should explain the Checkin time.
in the below photo i've placed the formula you have suggested and replaced the UTC with the Answer 4
This is the Error i got, below:
Hi @makpith,
What's the original time format of the Check-in? Are the "1582803512000" total seconds from a timestamp?
And seems like it is from the MS Form, could you please share more about the MS Form if it is? Such as the answer type, thank you.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
use the below expression to convert it to dateTime
addSeconds(‘1970-1-1’, add(div(int(triggerBody()?[‘answer4’]),1000), 19800), ‘yyyy-MM-dd hh:mm tt’)
kindly change the highlighted value with your corresponding timeZone seconds like india is ahead by 5:30hr so I added 19800
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
45 | |
44 | |
43 | |
43 | |
35 |
User | Count |
---|---|
85 | |
77 | |
62 | |
51 | |
47 |