Unanswered

Automatic Summary of Outlook Calendar

(0) Share

Report

Posted on by B_Wright

Hello,

I'm trying to make it so that I have an automated summary of my outlook calendar emailed to me every other Friday (bi-weekly) to keep track of my work log. Currently I have it set up as sending me the current week every other Friday. I cant seem to figure out what needs to be changed so it send me two weeks instead of one week.

Thanks!

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Sort by

srduval 1,796 Moderator on at

Like (0)

Report
Copy link

Link copied!

Post some screenshots of your current setup, and then we might be able to see what/where your setting needs to be changed.

Was this reply helpful? Yes No
B_Wright 8 on at

Like (0)

Report
Copy link

Link copied!

let me know if missed anything.
Thanks

Was this reply helpful? Yes No
B_Wright 8 on at

Like (0)

Report
Copy link

Link copied!

See response. Sorry I don't think I responded to your comment.

Was this reply helpful? Yes No
srduval 1,796 Moderator on at

Like (0)

Report
Copy link

Link copied!

In the formula where you set the value of end date, I assume if you're getting one week of data currently, you're adding 7 days, would it be as simple as changing the formula to be 14 days?

Was this reply helpful? Yes No
B_Wright 8 on at

Like (0)

Report
Copy link

Link copied!

So I changed the end date to 14 it didnt pull any of my outlook events from anything other than this week. It did changed the time frame at the top of the automated email however.

Was this reply helpful? Yes No
srduval 1,796 Moderator on at

Like (0)

Report
Copy link

Link copied!

What is the date value you have in your convert timezone in the outlook filter? I had assumed it was your end date variable, but if chnaged it and didn't get any more events, it must not be the end date,

Was this reply helpful? Yes No
B_Wright 8 on at

Like (0)

Report
Copy link

Link copied!

Do you mean this below? If so I copied the info below.

convertTimeZone(addHours(variables('v_EndDate'),27), 'UTC','Eastern Standard Time','MM/dd/yyyy HH:mm')

Was this reply helpful? Yes No
srduval 1,796 Moderator on at

Like (0)

Report
Copy link

Link copied!

Ok I think the issue might be in the do until section. Remove the dayofweek expression and replace with 14 (just type in the box) I think what's happening is it is counting until it gets to the value that is 14 days from today and stopping at the same day of the current week.

Was this reply helpful? Yes No