Calendar Post Item writing to today's date and not the selected Events date.

[GigaenvyTAG69]

Hi Pros,

I need some help that I have been banging my head on all week. Now it's time to call in the muscles here 😊 💪

Summary:

My Powerapp is not writing an Outlook V4 Post Item calendar event to the correct date. The times get posted correct.

Setup:

The SharePoint List has Single Text columns for 'Event Date', 'Start Time', and 'End Time'.

How it works:

User selects Event from a gallery and is presented with a confirmation registration screen where the Register button is located. This screen serves as a summary to confirm if the date, time, and other details are correct before clicking Register.

Problem:

When the user clicks the Register button in the RegistrationConfirmScreen, the code below creates the Outlook calendar event always for the current date rather than the desired 'Event Date' as selected from the gallery back on Screen1.

The Ask:

How can I get this thing to post for the correct date? Times are correct even though they are in different SP List columns. Can someone stretch and help me out so I can get over this roadblock?

Office365Outlook.V4CalendarPostItem(
    LookUp(
        Office365Outlook.CalendarGetTables().value,
        DisplayName = "Calendar"
    ).Name,
    LabelTitleValue.Text,
    EventView1.Selected.'Event Date' + Text(EventView1.Selected.'Start Time',DateTimeFormat.UTC),
    
    LabelEndTimeValue.Text,
    LabelFriendTimeZoneValue.Text,
    {body: LabelDescriptionValueHTML.HtmlText}
);

Thanks,

TAG

[StalinPonnusamy]

Hi @GigaenvyTAG69 

I suggest verifying the Datetime value. For testing, I created an event but make sure to send it as UTC time 

Office365Outlook.V4CalendarPostItem(
    "Calendar",
    "Stalin Test",
    DateTimeValue(DatePicker2.SelectedDate & " 10:00:00 PM"),
    DateTimeValue(DatePicker2.SelectedDate & " 10:30:00 PM"),
    "(UTC) Coordinated Universal Time",
    {body: RichTextEditor1.HtmlText}
)

[StalinPonnusamy]

Hi @GigaenvyTAG69 

Here is the converted date to UTC time

Office365Outlook.V4CalendarPostItem(
    "Calendar",
    "Stalin Test 4",
    DateAdd(
        DateTimeValue(
            DatePicker2.SelectedDate & " " & Time(
                Value(StartHourDropdown.Selected.Value),
                Value(StartMinutesDropdown.Selected.Value),
                0
            )
        ),
        TimeZoneOffset(),
        Minutes
    ),
    DateAdd(
        DateTimeValue(
            DatePicker3.SelectedDate & " " & Time(
                Value(EndHourDropdown.Selected.Value),
                Value(EndMinutesDropdown.Selected.Value),
                0
            )
        ),
        TimeZoneOffset(),
        Minutes
    ),
    "(UTC) Coordinated Universal Time",
    {body: RichTextEditor1.HtmlText}
)

Setup

[GigaenvyTAG69]

Thanks for this, but there is no DatePicker - the user is selecting an Items list from an Event gallery where the columns for 'Event Date' (date only), 'Start Time' and 'End Time' are all single text. I believe that's what I wrote above. In other words, I am pulling the Event details for the record from a Sharepoint List as I wrote above from a gallery. There is no minutes value neither as this is not a picker dropdown scenario as you provided above. 

[StalinPonnusamy · Accepted solution]

Hi @GigaenvyTAG69 

The concept is the same. Gets the information from the gallery or variable. And convert into proper Datetime.

Office365Outlook.V4CalendarPostItem(
    "Calendar",
    "Stalin Test 4",
    DateAdd(
        DateTimeValue(
            Gallery1.Selected.'Event Date' & " " & TimeValue(Gallery1.Selected.'Start Time')
        ),
        TimeZoneOffset(),
        Minutes
    ),
    DateAdd(
        DateTimeValue(
            Gallery1.Selected.'Event Date' & " " & TimeValue(Gallery1.Selected.'End Time')
        ),
        TimeZoneOffset(),
        Minutes
    ),
    "(UTC) Coordinated Universal Time",
    {body: "Test"}
)

[GigaenvyTAG69]

Hi @StalinPonnusamy 

Sorry I was away from work over the weekend and will check out the example above and let you know how it works. If successful I will flag this as solved. 🙂

TAG

[GigaenvyTAG69]

Thanks so much. I was using this before except I never tried DateTimeValue. I was using Time Value and trying to combine a date with time. This worked without the TimeOffset () param as it was altering the start time hours later.

[earlgarnethe]

Hi,

I'm new to PowerApps, I'm building a reservation app for my company. Now I'm trying to patch the date from my datepicker canvas to Outlook365 Calendar, is that even possible? I already tried my best but whenever I select a date from the datepicker, once I click the button with patch function, it will save in my SP List with correct selected date but in the outlook 365 calendar it post the date Today..

Please help me.