How to create event in outlook v4 when an list item is created

(0) Share

Report

Posted on by CU31081919-0

Hello,

I'm trying to build a flow that creates an outlook event when an item is created, but I keep running into this error:

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_event_(V4)': The parameter with value '"@triggerOutputs()?['body/DraftDueBy']"' in path 'item/start' with type/format 'String/date-time' is not convertible to type/format 'String/date-no-tz'.'.

It seems that it's related to the start/end time format - does anyone know how to adjust the expression or does anyone have another way of creating this flow?

my flow:

I want the event to be 1 hour long, so my end time expression is set to the following:

addHours(item()?['DraftsDueBy'],1,'yyyy-MM-dd')

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-chengfen-msft on at

Like (0)

Report
Hi @Cinna103 ,
Judging from the screenshots you provided, the cause of this problem is:
1. Starttime needs to format the date

Please try:
Start time:
formatDateTime(triggerOutputs()?['body/Dueby'],'yyyy-MM-dd')
triggerOutputs()?['body/Dueby'] is when the trigger returns
end time:
addHours(triggerOutputs()?['body/Dueby'],1,'yyyy-MM-dd')

Best Regards
Cheng Feng

Was this reply helpful? Yes No
CU31081919-0 26 on at

Like (0)

Report

Hi @v-chengfen-msft, this worked, but it made the event an all day event.

When I changed the formula from:
formatDateTime(triggerOutputs()?['body/DraftDueBy'],'yyyy-MM-dd') to
formatDateTime(triggerOutputs()?['body/DraftDueBy'],'yyyy-MM-ddThh:mm'), it created the event but it was in the wrong timezone.

1) flow
Start time:
formatDateTime(triggerOutputs()?['body/DraftDueBy'],'yyyy-MM-ddThh:mm')

End time:
addHours(triggerOutputs()?['body/DraftDueBy'],1,'yyyy-MM-ddThh:mm')

2) new item
3) event created, but wrong timezone

Was this reply helpful? Yes No
v-chengfen-msft on at

Like (0)

Report

Hi @Cinna103 ,
First way:
Please make sure that the time zone of the calendar is the same as the time zone of 【Create event】

The second way:
Use addHours() to make up for the time difference.

Best Regards
Cheng Feng

Was this reply helpful? Yes No