cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KCC
Regular Visitor

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
Highlighted
Community Support
Community Support

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
Highlighted
Community Support
Community Support

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
Regular Visitor

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
Community Support

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

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (8,035)