Add minutes to utcNow

[Gab00]

Hello

I'm trying to add 30 minutes to current timestamp but this error remains "Unable to process template language expressions in action 'Crear_evento_(V4)' inputs at line '0' and column '0': 'The template language function 'addMinutes' expects a timestamp as the first parameter, the number of minutes to add as the second parameter, and an optional format string as the third parameter."

This is my function: formatDateTime(addMinutes(utcNow()),30,'yyyy-MM-ddTHH:mm.ssZ')

Any idea? Thanks in advance!

[Expiscornovus]

Hi @Gab00,

It looks like you have a ) character directly after the UtcNow. This makes the expression invalid. Try moving it after the 30 minutes value.

I would also suggest the 'yyyy-MM-ddTHH:mm:ss' format. I believe that one is the expected format in the Create Event (V4) action.

Try this expression instead:

formatdatetime(addMinutes(utcNow(), 30), 'yyyy-MM-ddTHH:mm:ss')

[ScottShearer]

@Gab00 

You don't need the formatDateTime() expression

[Gab00]

That worked but creates an event with a 3.5hr duration instead of 30min ?? I don't understand why tho

[Gab00]

I need to be able to incluide it into a new calendar task where a start and finish time are required. My start time is the utcNow and this one would be the finish one.

[Expiscornovus · Accepted solution]

Hi @Gab00,

You are right @ScottShearer you don't need the formatdatetime function 😀

@Gab00, 

Try this for the Start Time

utcNow('yyyy-MM-ddTHH:mm:ss')

And this for the End Time

addMinutes(utcNow(), 30, 'yyyy-MM-ddTHH:mm:ss')

That should result in a 30 minute event.

[ScottShearer]

@Gab00 

I don't know why that is happening for you.  Please post screen shots of your Flow.

[Gab00]

That worked but the event is created with a different time zone, it's doesn't match with my time, do you know how do I fix that? 

[Chriddle · Accepted solution]

convertTimeZone(addMinutes(utcNow(), 30), 'UTC', 'Central Standard Time')

[Gab00]

Thanks Chriddle! I had to apply converttimezone to the utcnow in the starting time, but it works ok now!

[ninjaryder1st]

@Expiscornovus 

The code provided seems to create a meeting that adds 4 or 6 hours, plus the 30 min duration or number of minutes added to the "addminutes () " function.   Any idea why or how to resolve it to only add 30 minutes to "now"  

[ninjaryder1st]

@Chriddle 

Thank you.. This code/fxn resolves the issue with adding 6 hours with the desired 30 minutes, instead of solely the 30 minutes desired.