Office365 Connectivity V4CalendarPostItem

[Tia]

Hi All, 

I am trying to stop my Calendar invite from sending to the person saving the item. My current coding is calling the users Calendar which I do not want it to, but I can't seem to replace it out successfully? 

I believe I need to replace this line with something, Anyone got any suggestions? 

LookUp(Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar").Name,

Current Full Code on select of a button:

UpdateContext({VarMode: View}); SubmitForm(Form_DC);
Office365Outlook.V4CalendarPostItem(
//Logged in users calendar (Might need to change to selected person)
//ThisItem.'Email',
LookUp(Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar").Name,
// Subject
"Duty Coordinator - " &ThisItem.Office,
//Time Start + UTC timezones etc
DateAdd(DateTimeValue(VarStart.Text),TimeZoneOffset(), Minutes),
//Time End + UTC timezones etc
DateAdd(DateTimeValue(VarEnd.Text), TimeZoneOffset(), Minutes),
//Timezone for Meeting
"(UTC+10:00) Canberra, Melbourne, Sydney",
{requiredAttendees: ThisItem.'Staff Member'.Email,
responseRequested: true,
location: ThisItem.Location,
importance:"normal",
showAs:"free",
isReminderOn: true,
reminderMinutesBeforeStart: 15}
);

Thank you!!!

Kind Regards,

Tia

[v-yutliu-msft]

Hi @Tia ,

"Office365Outlook.V4CalendarPostItem" is used to create event.

Its first parameter is calendar id.

"Office365Outlook.CalendarGetTables().value" is used to return calendars.

LookUp(Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar").Name

 So this formula will return one calendar's Name.

All the formulas are not related to "Email".

So could you describe more clearly about your demands?

What do you want by using "Office365 Connectivity V4CalendarPostItem"?

What kind of  calendar id do you want to use for this function?

Best regards,

[Tia · Accepted solution]

We ended up creating a flow instead of housing it within the powerapp. 

When an item on the list is edited or modified >

Create event (v4) 

Set to a Calendar that isn't person-specific

Also added in the StartTime and EndTime as patched fields to allow the flow to grab better and format appropriately. 

In this App there is a singular field that gets modified/changed (Staff Member)

[mikeInTheCommun]

You have to post a non UTC time format of "yyyy-mm-ddThh:mm:ss.fff" and you have to submit a time zone in this format:  "Eastern Standard Time" or "Central Standard Time" or "US Mountain Standard Time" or "Alaskan Standard Time" etc (you can get these text threads by making a meeting and choosing your desired time zone then use the formula to collect them from Office365Outlook.GetEventsCalendarViewV2 and look at the TimeZone field, which I verified does post to the right time slot.  Note that if you include a "Z" at the end of your datetime format, it will post as UTC no matter which time zone you specify