Skip to main content

Notifications

Community site session details

Community site session details

Session Id : IBJC0QiBBdR1w+lF0P/Yer
Power Apps - Building Power Apps
Unanswered

Display Calendar from Outlook, rolling 2 weeks

Like (0) ShareShare
ReportReport
Posted on 1 May 2023 20:52:09 by 619

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:
  • rjsdavis Profile Picture
    6 on 12 Jun 2024 at 14:38:59
    Re: Display Calendar from Outlook, rolling 2 weeks

    To help other people googling the same problem. 

    If you've solved it already, you didn't bother to update your own post with the solution which is a little unhelpful. 

    You're welcome. 

  • CharlesBrewer Profile Picture
    619 on 12 Jun 2024 at 14:07:38
    Re: Display Calendar from Outlook, rolling 2 weeks

    This is over a year old why did you respond to this >.>

  • rjsdavis Profile Picture
    6 on 10 Jun 2024 at 22:33:42
    Re: Display Calendar from Outlook, rolling 2 weeks

    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.

  • CharlesBrewer Profile Picture
    619 on 10 May 2023 at 14:03:02
    Re: Display Calendar from Outlook, rolling 2 weeks

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

  • v-zhoqian-msft Profile Picture
    Microsoft Employee on 10 May 2023 at 01:59:11
    Re: Display Calendar from Outlook, rolling 2 weeks

    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.

     

  • CharlesBrewer Profile Picture
    619 on 09 May 2023 at 20:54:16
    Re: Display Calendar from Outlook, rolling 2 weeks

    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?

    CharlesBrewer_0-1683665636838.png

     

  • v-zhoqian-msft Profile Picture
    Microsoft Employee on 09 May 2023 at 07:10:06
    Re: Display Calendar from Outlook, rolling 2 weeks

    Hi @CharlesBrewer ,

     

    You could change these two numbers:

    vzhoqianmsft_0-1683616177898.png

     

     

     

     

    Best Regards,

    Habsburg Qian

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

  • CharlesBrewer Profile Picture
    619 on 08 May 2023 at 15:09:53
    Re: Display Calendar from Outlook, rolling 2 weeks

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

    CharlesBrewer_0-1683558570364.png

     

  • CharlesBrewer Profile Picture
    619 on 08 May 2023 at 15:02:44
    Re: Display Calendar from Outlook, rolling 2 weeks

    @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.

  • v-zhoqian-msft Profile Picture
    Microsoft Employee on 03 May 2023 at 01:44:46
    Re: Display Calendar from Outlook, rolling 2 weeks

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 89 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 60

#3
stampcoin Profile Picture

stampcoin 48

Overall leaderboard