Announcements
I have a table with a column with the "time" datatype.
Byt when i fetch data from it, it gets this weird formatting.
07:03:22 becomes PT7H3M22S.
Any way of getting Power Automate to do this like normal people?
Hi @shakudu ,
The direct method is to extract numbers through the split function:
first(split(outputs('Compose'),'H'))
first(split(last(split(outputs('Compose'),'H')),'M'))
first(split(last(split(last(split(outputs('Compose'),'H')),'M')),'S'))
formatDateTime(outputs('Compose_2'),'HH:mm:ss')
Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.
Thank you, i was hoping that there was a database-related solution to this but it seems Postgres is anything but straightforward in Power Automate.
I unfortunately had to make it with conditions forhours, minutes and seconds because is minutes was 00 in the database it would show up as 7H23S, messing up the split. But thank you for helping me find the way, i accepted your suggestion as the solution.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 248 Super User 2026 Season 1
11manish 204
Haque 179
