Sending Calendar Invites : fx ok in edit mode - after test, error message : "Status": 400,"message:"String not recognized as a valid DateTime

(0) Share

Report

Posted on by Mango99_uk

Hi - This function actually a few weeks ago but now it is not.

The syntax is fine when it is in edit mode 1. However, after testing 2, an error message (below) is displayed.

office365outlook.v4calendarpostitem failed: { "status": 400, "message": "string was not recognized as a valid datetime.\r\nclientrequestid: 96eac4b5-e4eb-4471-b059-ca9b67f9770d", "error": { "message": "string was not recognized as a valid datetime." },

Code:

Office365Outlook.V4CalendarPostItem([@Calendar].Selected.name,"Test",DateAdd(Now(),TimeZoneOffset(),Minutes),DateAdd(Now(),30+TimeZoneOffset(),Minutes),"(UTC) Coordinated Universal Time")

Syntax for Calendar dropdown seems to be ok.

Code:

Office365Outlook.CalendarGetTablesV2().value.name

Would appreciate if someone can help !

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

BlessedCobba 459 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Mango99_uk

Here is my working code for a Calendar invite

Office365Outlook.V4CalendarPostItem( LookUp(Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar").Name, selectedDesk.Description, Text(If(TimeZoneOffset(Now())/60 = vUTCHomeHrs, startTime, DateAdd(startTime,vUTCHomeHrs-TimeZoneOffset(Now())/60,Hours)),DateTimeFormat.UTC), Text(If(TimeZoneOffset(Now())/60 = vUTCHomeHrs, endTime, DateAdd(endTime,vUTCHomeHrs-TimeZoneOffset(Now())/60,Hours)),DateTimeFormat.UTC), "UTC", {body: htmlCalendarInviteBody.HtmlText }

Try updating the times to
Text(DateAdd(Now(),TimeZoneOffset(),Minutes),UTC)
Mango99_uk 12 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you ! @BlessedCobba. This worked !
Office365Outlook.V4CalendarPostItem( ddCalendar.SelectedText.name, "Meeting!!!", Text(DateAdd(Now(),TimeZoneOffset(),Minutes),UTC), Text(DateAdd(Now(),30+TimeZoneOffset(),Minutes),UTC), "UTC", {body: "Meeting Notes"} )

Would you know how I can add the time slots based on the combo/drop down lists?
StartDate1.SelectedDate & " " & " " & StartHour1.Selected.Value & "" & ":" & StartMin1.Selected.Value
This displays the date and time in a label box - seems to be errors.

Thanks !
BlessedCobba 459 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Mango99_uk

Is it erroring because of the double (( after DateAdd?