Formating SQL Time(0)

[Joenathan]

I'm getting the following error when attempting to use the FormatDateTime function with MSSQL Time(0) data format: the value provided for date time string 'PT15H44M' was not valid. The datetime string must match ISO 8601 format.'

I found the following solution for Power Apps but not sure how to use the solution in Power Automate

With( 
    Match( "PT7H30M", "PT(?:(?<hours>\d+)H)?(?:(?<minutes>\d+)M)?(?:(?<seconds>\d+)S)?" ),
    Time( Value( hours ), Value( minutes ), Value( seconds ) )
)

Any help would be much appreciated. 

Thank you

[v-LilyW-msft]

Hi @Joenathan 

Please refer to the following test and to see if it helps.

Add Compose action and rename to 'H'

first(split(last(split(outputs('Compose'),'T')),'H'))

Add Compose action and rename to 'M'

first(split(last(split(outputs('Compose'),'H')),'M'))

concat(outputs('H'),':',outputs('M'))

formatDateTime(outputs('Compose_2'),'HH:mm')

Results:

Hope the content above may help you.

Best Regards