Display Calendar from Outlook, rolling 2 weeks

(0) Share

Report

Posted on by CharlesBrewer

674

Hey folks,

I've done some googling and not sure how to get started here. Several people are going to be adding appointments to an Outlook calendar (I am happy to use Sharepoint calendar if it is easier). I need the app to get that information, and display it like a calendar, but only the current week and the following. Is this possible? I can't seem to find any information on how to possibly accomplish this so any assistance is greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

v-zhoqian-msft Microsoft Employee on at

Like (1)

Report
Hi @CharlesBrewer ,

You could add the calendar template screen. The calendar will be automatically generated.

Then set the "Visible" property of "Title2" control in MonthDayGallery1 to the following formula:

If(DateAdd(Today(),-Weekday(Today()))<=DateAdd(_firstDayInView,ThisItem.Value)
&&DateAdd(_firstDayInView,ThisItem.Value) <=DateAdd(Today(),13-Weekday(Today())),
!(DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days) - Weekday(DateAdd(_firstDayInView,ThisItem.Value,
TimeUnit.Days)) + 1 > _lastDayOfMonth),false)
By this way, calendar will only show the current week and the following.

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
CharlesBrewer 674 on at

Like (0)

Report

Hi @v-zhoqian-msft ,

Thanks for the reply. That's cool but not quite what I want. I need to just a large calendar where the appointments for those days are viewable. Here is a really crude drawing :

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

Like (0)

Report

Hi @CharlesBrewer ,

I think you could follow this video to make a large calendar with appointments first, and then refer to the formula I provided to only show two weeks:
Build CALENDAR Control in POWER APPS in Minutes | Connect to SharePoint List - YouTube

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
CharlesBrewer 674 on at

Like (0)

Report

@v-zhoqian-msft
I finally had time to go through this video. I'll try it...his appointments thing at the end is kind of what I want, but he connects it to Sharepoint, I'm unsure how to keep it connected to an Outlook calendar. The built in form functions would be nice too and I'll have to figure that out, I guess, he doesn't really go over it.

Was this reply helpful? Yes No
CharlesBrewer 674 on at

Like (0)

Report

Also @v-zhoqian-msft I set the title2 visibility as you mentioned, and I am getting Friday of last week

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

Like (0)

Report

Hi @CharlesBrewer ,

You could change these two numbers:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
CharlesBrewer 674 on at

Like (0)

Report
Hey @v-zhoqian-msft ,
So I changed it to the following and now it seems to show all 14 days. I hope this stays consistent?
If(DateAdd(Today(),1-Weekday(Today()))<=DateAdd(_firstDayInView,ThisItem.Value) &&DateAdd(_firstDayInView,ThisItem.Value) <=DateAdd(Today(),14-Weekday(Today())), !(DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days) - Weekday(DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days)) + 1 > _lastDayOfMonth),false)

My bigger concern though is, if you look at my screenshot below, and where the title box is, the previous week is still there, but blank. So what happens when it rolls into next week, or the beginning of the month? Will the dates move around or can I get the "2 weeks" to consistently stay in one spot? Does that make sense?

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

Like (0)

Report

Hi @CharlesBrewer ,

Yes, the dates will move. But all dates will be displayed in the current view, because if at the beginning and end of the month, these two lines will automatically add the dates that are not in this month.

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
CharlesBrewer 674 on at

Like (0)

Report

Soo...that's kind of useless then, if the dates are going to move around. 😕 How does one get them to not move around?

Was this reply helpful? Yes No
rjsdavis 6 on at

Like (1)

Report

Solution:

* Toggle to the Calendar view.

* Using the small navigational calendar in the top left corner, simply hold down the "CTRL" button, and using your mouse, highlight the range of dates that you want your view to be - in this example, start with the current day, and highlight the next 13 days to give you the 14 day view that you're looking for.

* You should now have a 14 day (2 week) view in your calendar.

* Now go to the VIEW > CHANGE VIEW menu options, and select "Select current view as a new view". When the dialogue box pops up, name it something like "2 Week View" - and you're done.

You should now find that whenever you toggle out calendar view, to your email or contacts or whatever, when you come back to the Calendar tab that it's still showing your new, custom 2 week view.

Was this reply helpful? Yes No