Unanswered

Trying to automate Outlook Calendar Event from Excel Table

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

I'm trying to create Outlook calendar events based on an excel table I have. The issue I'm having is the End Time. I can't seem to figure out the expression for addDays. I want the End Time to be 14 days after my Due Date(which is pulled from the table). Here's my flow:

Screen Shot 2021-06-23 at 4.53.04 PM.png

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-LilyW-msft on at

Like (0)

Report

Hi @Anonymous
Thank you for posting.
Excel stores internally the dates in a number format, so to use them in flow need to convert that integer to a date.
I created a simple flow and can create event that End time is 14 days after Due Date.
You can refer to the screenshots as below:
Use the following formula to get the correct date from excel.
Expression: formatDateTime(addDays('1899-12-30',int(items('Apply_to_each')?['Due Date'])),'yyyy-MM-dd')
Use the following formula to fill in the date that is 14 days after Due Date in the End time
Expression: addDays(outputs('Compose'),14,'yyyy-MM-dd')

Then save Flow and can test it.
This is my Excel
After Flow runs, two event will be created as below:
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Like (0)

Report

Thank you @v-LilyW-msft. That worked wonderfully.
I have another question regarding this. The excel file I have gets updated weekly and I want my calendar events to stay updated with them. Is there a way to just update the events without making new ones?

Was this reply helpful? Yes No