Hi we can insert time in sql but powerapps can't take it back to modify it. without a long function.
thank you to @CarlosFigueira for the function anyway:
Time( Value(Mid(ThisItem.Time, 3, Find("H", ThisItem.Time) - 3)), // Hour component If( IsBlank(Find("M", ThisItem.Time)), // Check if there is a minute component 0, // If not, the value is zero Value( // Otherwise take the substring between the rest of the value Left( // after the hour component and the 'M' indicator Mid( ThisItem.Time, If( IsBlank(Find("H", ThisItem.Time)), 3, Find("H", ThisItem.Time) + 1)), Find( "M", Mid( ThisItem.Time, If( IsBlank(Find("H", ThisItem.Time)), 3, Find("H", ThisItem.Time) + 1))) - 1))), If( IsBlank(Find("S", ThisItem.Time)), // Check if there is a second component 0, // If not, the value is zero Value( // Otherwise take the substring after the minute or hour indicator, Substitute( // remove the 'S' indicator, then take the value If( IsBlank( Find( "M", Mid( ThisItem.Time, If( IsBlank(Find("H", ThisItem.Time)), 3, Find("H", ThisItem.Time) + 1)))), Mid( ThisItem.Time, If( IsBlank(Find("H", ThisItem.Time)), 3, Find("H", ThisItem.Time) + 1)), Mid(ThisItem.Time, Find("M", ThisItem.Time) + 1)), "S", ""))))