cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karldenton
Level: Powered On

Condition is Blank

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)

 

flow.JPG

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Condition is Blank

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: 

 

Flow2.PNG

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.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

View solution in original post

11 REPLIES 11
Super User
Super User

Re: Condition is Blank

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?





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

karldenton
Level: Powered On

Re: Condition is Blank

Hi @MattWeston365 

 

The expression in end time is 

addMinutes(triggerBody()?['DueDate'],15)
karldenton
Level: Powered On

Re: Condition is Blank

Hi

Can anyone help with the addminutes expression?

Thanks

Super User
Super User

Re: Condition is Blank

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?





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

karldenton
Level: Powered On

Re: Condition is Blank

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
Super User
Super User

Re: Condition is Blank

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?





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

karldenton
Level: Powered On

Re: Condition is Blank

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

Super User
Super User

Re: Condition is Blank

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

Flow1.PNG 

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.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

Super User
Super User

Re: Condition is Blank

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.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

karldenton
Level: Powered On

Re: Condition is Blank

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

Super User
Super User

Re: Condition is Blank

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: 

 

Flow2.PNG

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.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 88 members 5,386 guests
Please welcome our newest community members: