Out Of Office Template issues

[Ahmed_Mamdouh]

Hi,

I'm new to powerapps and a task assigned to me regarding out of office, since we just migrated to the cloud.

I've just started using Out Of Office template, a brilliant app.

However, I'm facing some issues and need your help me sorting it out:

1- what if I needed to make all users in the company, which permission should be granted to these users in order to be able to use the app?

2- how can I insert a line in the internal response text that's generated by default? as the default text: "Thank you,Displayname" 

3- the auto-reply can't be canceled from the app (web or phone), and has to be disabled from the outlook.

4- creating out of office makes 2 things, enable the auto-reply on the outlook (it's ok) and creates an appointment with a name "out of office" but it shows as "Free" how can I change this to be "out of office"?

Thanks in advance 🙂

Ahmed

[v-bofeng-msft · Accepted solution]

Hi @Ahmed_Mamdouh :

Q1:what if I needed to make all users in the company,……

A:
First, you need to ensure that the user's lincense allows them to run a Canvas APP.I think this link will help you a lot
https://docs.microsoft.com/en-us/power-platform/admin/signup-for-powerapps-admin
Seondl,You need to share this app with these users.Please refere to this link:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/share-app

Q2:how can I insert a line in the internal response text ……

A:
Could you tell me what " internal response text" is ?Are you talking about the "Success!" Text (Label23) in SuccessScreen?If so,you can set it's Text property to

"Success!"&Char(13)&"Thank you "&User().FullName

Q3:the auto-reply can't be canceled from the app (web or phone), and has to be disabled from the outlook

A:
Whether to enable auto-reply is a function set in OutLook and cannot be set by PowerApps.

Q4:creating out of office makes 2 thing……

A:
If my understanding is correct, you only need to adjust the OnSelelct proeprty of the submit button.

Best Regards,

Bof

[sc0rpiongirl]

Hi Bo,

Thank you, first of all, for the direction.  I did encounter the same question and by searching "free" within the app I found the OnSelect Property of SubmitButton in ReviewScreen as you mentioned about in the most current MS Out of Office power app version.  The problem is even though changing the Show as ="Out of Office" will now show the title of the block as "Out of Office", it did NOT block user's calendar with the usual purple color and actually block the calendar of the user for the said time frame as unavailable.  In fact, with "Out of Office" showing on the title, the time slot still shows as "free" - please see the screenshot.  On the left I manually blocked OOF and on the right it's the Power App block.  If you click to open the one Power App created, it actually shows time as "Free" still although in the Submit button property I have changed it to "Out of office", that means changing it there only change the title of the event, not actually blocking the time off.  The expected result would be purple color blocking the availability of the Out of Office period.  How can we achieve that?  Would greatly appreciate your thoughts on that.

Scarlett

[sc0rpiongirl]

Since no one answered my question (supposedly it's an old thread and no one revisits it), I did some digging and figured this out.  Simply change the ShowAs parameter to "oof" (not "Out Of Office" as it would show in actual calendar view), it will serve the purpose. Hopefully this will help whoever runs into this similar problem

[ElasPinkman]

Hi, 

I still have a problem with the application related to the empty _myCalendarID value and showing conflicts (see zero all the time).

After your tip, my calendar doesn't change to purple, but it's probably a _myCalendarID problem.

Can you give me your code from:
App OnStart
Save button Onselect (ReviewScreen screen)

regards

Elas Pinkman 

[sc0rpiongirl]

A bit late reply but hopefully you have found solutions.  Anyways, here are the codes as you asked -

For App OnStart =

//gets user profile, sets count variables to 0, gets user calendar ID, creates time selection collection
Concurrent(
    Set(_myProfile, Office365Users.MyProfile()),
    Set(_clearedEventsCount, 0),
    Set(_inviteeCount, 0),
    Set(_myCalendarID, LookUp(Office365.CalendarGetTables().value, DisplayName = "Calendar").Name),
    ClearCollect(HoursList, 
     {Name:"12:00 am",Minutes:0}, {Name:"12:30 am",Minutes:30}, {Name:"01:00 am",Minutes:60}, {Name:"01:30 am",Minutes:90},
     {Name:"02:00 am",Minutes:120}, {Name:"02:30 am",Minutes:150}, {Name:"03:00 am",Minutes:180}, {Name:"03:30 am",Minutes:210},
     {Name:"04:00 am",Minutes:240}, {Name:"04:30 am",Minutes:270}, {Name:"05:00 am",Minutes:300}, {Name:"05:30 am",Minutes:330}, 
     {Name:"06:00 am",Minutes:360}, {Name:"06:30 am",Minutes:390}, {Name:"07:00 am",Minutes:420}, {Name:"07:30 am",Minutes:450}, 
     {Name:"08:00 am",Minutes:480}, {Name:"08:30 am",Minutes:510}, {Name:"09:00 am",Minutes:540}, {Name:"09:30 am",Minutes:570}, 
     {Name:"10:00 am",Minutes:600}, {Name:"10:30 am",Minutes:630}, {Name:"11:00 am",Minutes:660}, {Name:"11:30 am",Minutes:690}, 
     {Name:"12:00 pm",Minutes:720}, {Name:"12:30 pm",Minutes:750}, {Name:"01:00 pm",Minutes:780}, {Name:"01:30 pm",Minutes:810},
     {Name:"02:00 pm",Minutes:840}, {Name:"02:30 pm",Minutes:870}, {Name:"03:00 pm",Minutes:900}, {Name:"03:30 pm",Minutes:930},
     {Name:"04:00 pm",Minutes:960}, {Name:"04:30 pm",Minutes:990}, {Name:"05:00 pm",Minutes:1020}, {Name:"05:30 pm",Minutes:1050},
     {Name:"06:00 pm",Minutes:1080}, {Name:"06:30 pm",Minutes:1110}, {Name:"07:00 pm",Minutes:1140}, {Name:"07:30 pm",Minutes:1170},
     {Name:"08:00 pm",Minutes:1200}, {Name:"08:30 pm",Minutes:1230}, {Name:"09:00 pm",Minutes:1260}, {Name:"09:30 pm",Minutes:1290},
     {Name:"10:00 pm",Minutes:1320}, {Name:"10:30 pm",Minutes:1350}, {Name:"11:00 pm",Minutes:1380}, {Name:"11:30 pm",Minutes:1410}
    ),
    ClearCollect(ProgressTable,
        {Row:1, Text: "Time, and title"}, {Row: 2, Text: "Response type"}, {Row: 3, Text: "Email access"}, {Row: 4, Text: "Contacts"}, {Row: 5, Text: "Review"})

);
//gets user's calendar events for next 90 days, gets user's relevant people
Concurrent(
    ClearCollect(FutureCalendarEvents, Office365.GetEventsCalendarViewV2(_myCalendarID, Text(Now(), DateTimeFormat.UTC), Text(DateAdd(Now(), 90, TimeUnit.Days))).value),
    ClearCollect(MyPeople, RenameColumns(Office365Users.RelevantPeople(_myProfile.Id).value, 
      "birthday", "Birthday", "companyName", "CompanyName", "department", "Department", "displayName", "DisplayName", "givenName", "GivenName", "id", "Id", "jobTitle",        "JobTitle", "officeLocation", "OfficeLocation", "userPrincipalName", "UserPrincipalName")
    )
)

I did make some modifications just so you know so you might want to test and double check the codes when using them on your app.

Codes on Save button (Review Screen) OnSelect =

//start and end times need to be passed into the connector in UTC time format
Set(_startTimeUTC, Text(DateAdd(_oOFRecord.StartDate, _oOFRecord.StartTime.Minutes, TimeUnit.Minutes), DateTimeFormat.UTC));
Set(_endTimeUTC, Text(DateAdd(_oOFRecord.EndDate, _oOFRecord.EndTime.Minutes, TimeUnit.Minutes), DateTimeFormat.UTC));
Set(_createdOOF, true);

Concurrent(
    //schedules the automatic replies
    Office365.SetAutomaticRepliesSetting("Scheduled", If(_sendExternalResponse, "All", "None"), 
    {ScheduledStartDateTimeOffset: _startTimeUTC,
     ScheduledEndDateTimeOffset: _endTimeUTC,
     InternalReplyMessage: InternalMessage.HtmlText,
     ExternalReplyMessage: ExternalMessage.HtmlText}),
    //creates an event in your outlook calendar with ShowAs = Out of Office and ResponseRequested = false
    Set(_createdCalendarEvent, Office365.V2CalendarPostItem(_myCalendarID, _oOFRecord.Title, _startTimeUTC, _endTimeUTC, 
    {Body:_internalMessage, IsHtml: true, ShowAs: "oof", ResponseRequested: false})));
    Navigate(WelcomeScreen, BorderStyle.None)