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

Create Outlook Event with Future Calculated Date

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Create Outlook Event with Future Calculated Date

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.
4.PNG

 

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Create Outlook Event with Future Calculated Date

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.
4.PNG

 

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

KCC
Level: Powered On

Re: Create Outlook Event with Future Calculated Date

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

 

 

 

Community Support Team
Community Support Team

Re: Create Outlook Event with Future Calculated Date

Hi KCC,

 

Please add a double quotes on the adddays function.

 

So your Compose action should be looking like below:

4.PNG

 

Best regards,
Mabel Mao

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

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 Solution Authors
Top Kudoed Authors
Users online (6,722)