
Announcements
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!
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