Condition is Blank

[karldenton]

Hi

We have a sharepoint list with a column of DueDate.

I'd like a flow so when a list item is modified and a due date is entered, it creates an outlook calendar event.

I've done a conidition so if due date isn't blank then create event (see below)

It errors on 2 things:

Condition: ActionFailed.An action failed. No dependent actions succeeded.

Create event - The value 'Coordinated Universal Time' of parameter 'EndTimeZone' is invalid.
clientRequestId: 40226b31-ddea-4d27-98a8-b54be3e94d40
serviceRequestId: 902151e9-09e7-48ac-a2c5-10830c2bc756

Any help appreciated

Thanks

[MattWeston365]

Hi @karldenton the error that gets thrown in the condition isn't anything to be concerned about, it's basically saying that I tried to do something but couldn't.

The error is related to your creation action. What is the expression that you're using in the End Time?

[karldenton]

Hi @MattWeston365 

The expression in end time is 

addMinutes(triggerBody()?['DueDate'],15)

[karldenton]

Hi

Can anyone help with the addminutes expression?

Thanks

[MattWeston365]

Hi @karldenton I'm trying to recreate your issue as your expression is correct. Unfortunately I'm not having much luck at the moment. I have a field which is called DueDate (Date Field) and I've managed to take that value, add 15 minutes to it and then update another field called DateTimeField(Date Field with Time). Sorry if it seems like a patronising question, but can I confirm that the DueDate field is a Date field rather than text?

[karldenton]

Hi Matt

Thanks. Correct that the due date is a date field.

These were the times getting passed in the flow:

Start time

2019-03-31T17:42:42Z

End time

2019-03-31T17:57:42.0000000Z

I've taken out the timezone but now I get:

Id is malformed.
clientRequestId: 64080629-cb35-494f-a9a7-c9f9f0797b33
serviceRequestId: 8e0eff5f-76bb-4214-bdcf-c2193ee147eb

[MattWeston365]

I think I'm getting somewhere, helps if I look at your screenshot properly. I've now changed my action to Create an Event, and I'm getting the same ID issue. What is the value of the Dynamic Content in the Calendar field?

[karldenton]

Many thanks

The dynamic content in the calendar ID is the "Assigned to Email". This is the person who its assigned to in the sharepoint list

[MattWeston365]

Ahhh, that's the cause of the problem. I believe that action will only allow you to interact with the calendars which belong to you. If you look at the ID which is used when you select one of your own calendars it explains why you're getting that error

 

I'm just trying to see if there's an easy way of getting that ID for someone else or if there's an alternative way of doing it.

[MattWeston365]

One possibility would be add the Assigned To user as an attendee in the Create event (V2) action. Click on Show Advanced Options and then use the Required Attendees field.

[karldenton]

Thanks. I've tried running again with my email address typed into the calendar ID field. Its using my email in the connector but still gets the same error

[MattWeston365 · Accepted solution]

Yes, that's correct, it won't accept an email address as an ID. If you clear out the dyncamic content, it should give you the option of selecting the following: 

As the connection to O365 Outlook it will only allow you to access your own calendar from here, and I don't think it would let you create it explicitly in someone elses calendar unless you have access to create items on their behalf.

What I would consider is doing the following:

1. Create a Service Account which would be used for the Flow

2. Create the connection to Outlook using the Service Account

3. Invite the person in "Assigned to" to the event

This way the email would originate and populate the master calendar for the service account, rather than yours.