Creating an invent for Outlook

(0) Share

Report

Posted on by chtraywick

184

Hi:

We have some recurring events working but cannot seem to find the key words in the V4CalendarPostItem to getting something like schedule a meeting on the second Tuesday of each month.

The following works so far:

Office365Outlook.V4CalendarPostItem(LookUp(Office365Outlook.CalendarGetTablesV2().value, name ="Calendar").name,
txteventname_1.Text,
// start time
DateTimeValue(dtestarttime_1.SelectedDate & " " & drpstarthour_1.Selected.Value & ":" & drpstartminutes_1.Selected.Value ),
// end time
DateTimeValue(dteendtime_1.SelectedDate & " " & dteendhour_1.Selected.Value & ":" & dteendminute_1.Selected.Value ),
"Eastern Standard Time",
{
requiredAttendees: Concat(drprequiredattendees_1.SelectedItems,Email, ";") ,
optionalAttendees: Concat(drpoptionalattendees.SelectedItems, Email , ";") ,
location: roomsdrp_1.Selected.Value,
importance: "normal",
isAllDay: false,
Body: "This meeting has either already been placed on your calendar or you have been asked to attend, please respond if you see a prompt in your email to do so",

// weekly monthly etc.
recurrence: Text(drpby.Selected.Value),

// not sure about the following setting
//interval: 2,

Sun thru Sat using a number
daysOfWeek: Value(varDayValue),
//index: "second", is this how we would get the second Tuesday of each month?
//RecurrenceEnd: Text(Last(colNthDays).EndDate, "[$-en-US]yyyy-mm-dd"),

// Number of weeks or months
numberOfOccurences: Value(drprepaeat_1.Selected.Value),
reminderMinutesBeforeStart: 15,
isReminderOn: true
}
);

Any help would be greatly appreciated.

Chuck

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey @chtraywick

can u try this:

Office365Outlook.V4CalendarPostItem( LookUp(Office365Outlook.CalendarGetTablesV2().value, name ="Calendar").name, txteventname_1.Text, // start time DateTimeValue(dtestarttime_1.SelectedDate & " " & drpstarthour_1.Selected.Value & ":" & drpstartminutes_1.Selected.Value ), // end time DateTimeValue(dteendtime_1.SelectedDate & " " & dteendhour_1.Selected.Value & ":" & dteendminute_1.Selected.Value ), "Eastern Standard Time", { requiredAttendees: Concat(drprequiredattendees_1.SelectedItems, Email, ";"), optionalAttendees: Concat(drpoptionalattendees.SelectedItems, Email , ";"), location: roomsdrp_1.Selected.Value, importance: "normal", isAllDay: false, Body: "This meeting has either already been placed on your calendar or you have been asked to attend, please respond if you see a prompt in your email to do so", // Set up recurrence pattern recurrence: { pattern: { type: "absoluteMonthly", interval: 1, // Every 1 month daysOfWeek: ["Tuesday"], index: "Second" // Second occurrence of the specified day }, range: { type: "endDate", // You can change this to "noEnd" or "numbered" startDate: Text(dtestarttime_1.SelectedDate, "[$-en-US]yyyy-mm-dd"), endDate: Text(dteendtime_1.SelectedDate, "[$-en-US]yyyy-mm-dd"), // Specify an end date if needed numberOfOccurrences: Value(drprepaeat_1.Selected.Value) // Optional if you use endDate } }, reminderMinutesBeforeStart: 15, isReminderOn: true } );

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
chtraywick 184 on at

Like (0)

Report
Copy link

Link copied!

Thank you will test this and get back to you.

Chuck

Was this reply helpful? Yes No
chtraywick 184 on at

Like (0)

Report
Copy link

Link copied!

Hi:
Applied the changes that were indicated, and we get an error message The 'recurrence' column in the data source you're updating expects a 'Text' type and you're using a 'Record' type.
Must have entered something wrong and having trouble finding it.
Here is the entire routine:
Office365Outlook.V4CalendarPostItem(LookUp(Office365Outlook.CalendarGetTablesV2().value, name ="Calendar").name,
txteventname_1.Text,
// start time
DateTimeValue(dtestarttime_1.SelectedDate & " " & drpstarthour_1.Selected.Value & ":" & drpstartminutes_1.Selected.Value ),
// end time
DateTimeValue(dteendtime_1.SelectedDate & " " & dteendhour_1.Selected.Value & ":" & dteendminute_1.Selected.Value ),
"Eastern Standard Time",
{
requiredAttendees: Concat(drprequiredattendees_1.SelectedItems,Email, ";") ,
optionalAttendees: Concat(drpoptionalattendees.SelectedItems, Email , ";") ,
location: roomsdrp_1.Selected.Value,
importance: "normal",
isAllDay: false,
Body: "This meeting has either already been placed on your calendar or you have been asked to attend, please respond if you see a prompt in your email to do so",
//recurrence: Text(drpby.Selected.Value),
//type: "relativeMonthly",
//interval: 1,
//daysOfWeek: 3,
//index: "Second",
//RecurrenceEnd: Text(Last(colNthDays).EndDate, "[$-en-US]yyyy-mm-dd"),
//numberOfOccurrences: Value(drprepaeat_1.Selected.Value),*/
// set up recurrence pattern
recurrence: {
pattern: {
type: "absoluteMonthly",
interval: 1, // Every 1 month
daysOfWeek: ["Tuesday"],
index: "Second" // Second Tuesday each month
},
range: {
type: "endDate",
startDate: Text(dtestarttime_1.SelectedDate, "[$-en-US]yyyy-mm-dd"),
//endDate: Text(Last(colNthDays).EndDate, "[$-en-US]yyyy-mm-dd"),
numberOfOccurrences: Value(drprepaeat_1.Selected.Value)
}
},
//numberOfOccurrences: Value(drprepaeat_1.Selected.Value),
reminderMinutesBeforeStart: 15,
isReminderOn: true
}
);
Thank you for looking at this and appreciate any thoughts you might have.

Also do you know of any MS docs that cover this in detail?
Thank you again
Chuck

Was this reply helpful? Yes No