Power Platform Community Forum Thread Details

Hi all,

Im trying to set the time for the events based on in put form a microsoft form.

Imputs from the person filling out the form Date Required, Time of pick up

So im trying to create the event with start time to be equal to the date required and time of pick up.

I can see that calanders require a YYYY-MM-DDThhmmss format is this first correct?

What i have been trying is

First to format the Pick up time as it is enterd as a 24hr time

formatDateTime(Pickuptime,hh) so should give a string of say eg 17,02,22

Then

Addhours(DateRequred,(formatDateTime(Pickuptime,hh),'yyyy-M-ddThh:mm:ss')

but im getting a

InvalidTemplate. Unable to process template language expressions in action 'Create_event_(V4)' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '1700' was not valid. The datetime string must match ISO 8601 format.'.

the exact formula

addHours(items('Apply_to_each_2')?['field_5'],formatDateTime(items('Apply_to_each_2')?['field_6'],'HHmm'))

Thanks in advance

Brendan

Categories: