Setting Task Due date based on Event start date

[areddington]

Hi!

I'm really struggling here!

The flow I'm creating is triggered by an event (outlook 365).

I'm creating a set of tasks that are based on the event date.

For example:

Say I have an event that is due to start on 01/19/2021.

I need the start date of the generated task to be the event date.

The tasks that need to be completed will have due dates of 1 day or 1 week after the event date.

Nothing I'm doing seems to generate a successful flow. I'm still pretty new to power automate but I feel like I've tried everything.

I appreciate any help!

[fchopo · Accepted solution]

Hello @areddington 

You can work with some datetime functions and expressions, using the "compose" action for example.

1) Get the start the date: For example, if the event is going to start in 15 days you could use this expression to get that date:

addDays(utcNow(),15)

utcNow() is a function that gets the current time (UTC).

2) If you want to add some days or weeks to that date, you could use an expression like that:

addDays(outputs('Compose-EventDate'),7)

where outputs('compose-eventdate') is the output of the previous action. Have a look:

After that, you could use the ouputs of the different compose actions in Outlook or Planner to assign the tasks.

Hope it helps!

Ferran