You’re offline. This is a read only version of the page.
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?
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.
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.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
