I've got one more issue to resolve.
Data source is an Excel workbook. I wrestled with getting the 'InTime' and 'OutTIme' (both Date columns) over; They are now coming over fine.
Last issue is 'WaitTime'.
In Excel the 'WaitTime' column is formatted as 'Time'
Power Automate and is seeing 'WaitTime' as a decimal value, as shown in Compose 3 below.
I am using the following expression in the 'WaitTime' of the 'Create item' and getting back the above error.
formatDateTime(items('Apply_to_each')?['WaitTime'],'hh:mm:ss')
