Answered

Create Outlook Event with Future Calculated Date

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a flow that is working well so far creating folders and copying, renaming and date-stamping Office Documents into folders.

I would like to add Create Outlook Event (V2) to create a follow up reminder event with a date based on "Created" date + 2 weeks.

Is there a way to calculate this future date using the "Created" dynamic content?
(With this method I could then test if the event is truly being created two weeks from item creations immediately upon list item creation.)

Or should I use the DELAY block to delay creation of the Create Outlook Event with reminder at which time the event will be created and remind me on the same day?
(With this method, I wouldn't be able to test it directly. I would have to create a new list item and wait 2 weeks to see if it actually worked. Nor would I be able to manage or cancel any upcoming event reminds. Though I guess I could set the delay for 5 mins to test)

That said, I would rather calculate the date based on Created Date if possible.

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yamao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi KCC,

Please consider to use function adddays in the Workflow definition language. Using this function, you could create a reminder event with a date based on Created date + 2 weeks.

A Delay action could also be your choice. As you said, you could test with 5 minutes. If it works well, you could change the Count and Unite to 14 days.

Please try it on your side and feel free reply if you need more help.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the tip however it didn't seem to work.
I used a previous Compose step in my process as an example...
@formatDateTime(triggerBody()?['Created'],'ddMMyyyy')

and created a new Compose step...
@adddays(triggerBody()?['Due Date'], 14)

The flow threw an error (for reasons obvious as seen below)
String was not recognized as a valid DateTime.

MY FLOW

OUTPUT

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi KCC,

Please add a double quotes on the adddays function.

So your Compose action should be looking like below:

Best regards,
Mabel Mao

Was this reply helpful? Yes No