web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Formatting minutes to ...
Power Automate
Unanswered

Formatting minutes to hours and minutes properly

(0) ShareShare
ReportReport
Posted on by

I am trying to send out an automated email that lets people know when they're on call starts and ends with the data coming from a SharePoint file. The data in the SharePoint is a number seen below

danielC1998_0-1667206633787.png

In the email I want it to say they're start time in 24 hour clock. So I wrote the following code the start and end time:

concat(div(triggerOutputs()?['body/StartMinute'],60),':',mod(triggerOutputs()?['body/StartMinute'],60))
concat(div(triggerOutputs()?['body/EndMinute'],60),':',mod(triggerOutputs()?['body/EndMinute'],60))
However, the time examples I have done the emails turns out like this
danielC1998_1-1667206850463.png
danielC1998_2-1667206914315.png

Is there anyway of making it show 24 hour time 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard