Send An Email Notification Using Office 365 Outlook Connector In PowerApps

Introduction

 

This article is a follow-up to my previous articles listed below. If you wish to first understand the basic connectors (Mail and Outlook.com) used in PowerApps you can refer to the below articles first and come back here for the Office365Outlook connector and its relevant out-of-the-box actions.

• Send An Email Notification Using Mail Connector In PowerApps
• Send An Email Notification Using Outlook.com Connector In PowerApps

Office365Outlook Connector

Office365Outlook connector is a cloud-based service that is designed to help build reliable applications according to your business requirements.

 

In this article, you will see Office365Outlook connector actions available out of the box in Power Apps as well the deprecated actions which will be eventually removed. 

The throttling limit remains the same as the Outlook.com connector that is 300 API calls per connection and renewed after 60seconds.

 

List of available actions (excluding deprecated actions) Table 1,

 

Action in Power Apps	Operation ID
Create contact (V2)	ContactPostItem_V2
Create event (V4)	V4CalendarPostItem
Delete contact (V2)	ContactDeleteItem_V2
Delete email (V2)	DeleteEmail_V2
Delete event (V2)	CalendarDeleteItem_V2
Export email (V2)	ExportEmailV2
Find meeting times (V2)	FindMeetingTimesV2
Flag email (V2)	FlagV2
Forward an email (V2)	ForwardEmail_V2
Get Attachment (V2)	GetAttachmentV2
Get calendar view of events (V3)	GetEventsCalendarViewV3
Get calendars (V2)	CalendarGetTablesV2
Get contact (V2)	ContactGetItemV2
Get contact folders (V2)	ContactGetTablesV2
Get contacts (V2)	ContactGetItemsV2
Get email (V2)	GetEmailV2
Get emails (V3)	GetEmailsV3
Get event (V3)	V3CalendarGetItem
Get events (V4)	V4CalendarGetItems
Get mail tips for a mailbox (V2)	GetMailTipsV2
Get room lists (V2)	GetRoomLists_V2
Get rooms (V2)	GetRooms_V2
Get rooms in room list (V2)	GetRoomsInRoomList_V2
Mark as read or unread (V3)	MarkAsRead_V3
Move email (V2)	MoveV2
Reply to email (V3)	ReplyToV3
Respond to an event invite (V2)	RespondToEvent_V2
Send an email (V2)	SendEmailV2
Send an email from a shared mailbox (V2)	SharedMailboxSendEmailV2
Send approval email	SendApprovalMail
Send email with options	SendMailWithOptions
Set up automatic replies (V2)	SetAutomaticRepliesSetting_V2
Update contact (V2)	ContactPatchItem_V2
Update event (V4)	V4CalendarPatchItem
Update my contact's photo	UpdateMyContactPhoto

 

Syntax of each action listed in Table 1 

 

ContactPostItem_V2 

ContactPostItem_V2(
 folder,
 givenName,
 headPhones,
    {
    id:Text,
    parentFolderId:Text,
    birthday:DateTime,
    fileAs:Text,
    displayName:Text,
    initials:Text,
    middleName:Text,
    nickName:Text,
    surname:Text,
    title:Text,
    generation:Text,
    emailAddresses:Table,
    imAddresses:Table,
    jobTitle:Text,
    companyName:Text,
    department:Text,
    officeLocation:Text,
    profession:Text,
    businessHomePage:Text,
    assistantName:Text,
    manager:Text,
    businessPhones:Table,
    mobilePhone:Text,
    homeAddress:Record,
    businessAddress:Record,
    otherAddress:Record,
    yomiComanyName:Text,
    yomiGivenName:Text,
    yomiSurname:Text,
    categories:Table,
    cangeKey:Text,
    createdDateTime:DateTime,
    lastModifiedDateTime:DateTime
    }
)

V4CalendarPostItem

V4CalendarPostItem(
 table,
 subject,
 start,
 end,
 timeZone,
    {
    requiredAttendees:Text,
    optionalAttendees:Text,
    resourceAttendees:Text,
    body:Text,
    location:Text,
    importance:Text,
    isAllDay:Boolean,
    recurrence:Text,
    recurrenceEnd:Text,
    numberOfOccurences:Number,
    reminderMinutesBeforeStart:Number,
    isReminderOn:Boolean,
    showAs:Text,
    responseRequested:Boolean,
    sensitivity:Text
    }
)

ContactDeleteItem_V2

ContactDeleteItem_V2(
 folder,
 id
)

DeleteEmail_V2

DeleteEmail_V2(
 messageId,
    {
    mailboxAddress:Text
    }
)

CalendarDeleteItem_V2

CalendarDeleteItem_V2(
 calendar,
 event
)

ExportEmailV2

ExportEmail_V2(
 messageId,
    {
    mailboxAddress:Text
    }
)

FindMeetingTimesV2

FindMeetingTimesV2(
    {
    RequiredAttendees:Text,
    OptionalAttendees:Text,
    ResourceAttendees:Text,
    MeetingDuration:Number,
    Start:DateTime,
    End:DateTime,
    MaxCandidates:Number,
    MinimumAttendeePercentage:Text,
    isOrganizerOptional:Boolean,
    ActivityDomain:Text
    }
)

FlagV2

FlagV2(
 messageId,
    {
    mailboxAddress:Text,
    flag:Record
    }
)

ForwardEmailV2

ForwardEmailV2(
 message_id,
 ToRecipients,
    {
    mailboxAddress:Text,
    Comment:Text
    }
)

GetAttachmentV2

GetAttachmentV2(
 messageId,
 attachmentId,
    {
    mailboxAddress:Text
    }
)

GetEventsCalendarViewV3

GetEventsCalendarViewV3(
 calendarId,
 startDateTimeUtc,
 endDateTimeUtc,
    {
    '$filter':Text,
    '$orderby':Text,
    '$top':Number,
    '$skip':Number,
    search:Text
    }
)

CalendarGetTablesV2

CalendarGetTablesV2(
    {
    skip:Number,
    top:Number,
    orderBy:Text
    }
)

ContactGetItemV2

ContactGetItemV2(
 folder,
 id
)

ContactGetTablesV2

ContactGetTablesV2()

ContactGetItemV2

ContactGetItemV2(
 folder,
 id
)

ContactGetTablesV2

ContactGetTablesV2()

ContactGetItemsV2

ContactGetItemsV2(
 folder,
    {
    '$filter':Text,
    '$orderby':Text,
    '$top':Number,
    '$skip':Number,
    }
)

 GetEmailV2

GetEmailV2(
 messageId,
    {
    mailboxAddress:Text,
    includeAttachments:Boolean
    }
)

 GetEmailsV3

GetEmailsV3(
    {
    folderPath:Text,
    to:Text,
    cc:Text,
    toOrCc:Text,
    from:Text,
    importance:Text,
    fetchOnlyWithAttachments:Boolean,
    subjectFilter:Text,
    fetchOnlyUnread:Boolean,
    fetchOnlyFlagged:Boolean,
    mailboxAddress:Text,
    includeAttachments:Boolean,
    searchQuery:Text,
    top:Number
    }
)

V3CalendarGetItem

V3CalendarGetItem(
 table,
 id
)

V4CalendarGetItems

V4CalendarGetItems(
 table,
    {
    '$filter':Text,
    '$orderby':Text,
    '$top':Number,
    '$skip':Number,
    }
)

GetMailTipsV2

GetMailTipsV2(
 MailTipsOptions,
 EmailAddresses
)

GetRoomListsV2 

GetRoomListsV2()

GetRoomsV2 

GetRoomsV2

GetRoomsInRoomListV2

GetRoomsInRoomListV2(
 room_list
)

MarkAsReadV3

MarkAsReadV3(
 messageId,
 isRead,
    {
    mailboxAddress:Text
    }
)

MoveV2

MoveV2(
 messageId,
 folderPath,
    {
    mailboxAddress:Text
    }
)

ReplyToV3

ReplyToV3(
 messageId,
    {
    mailboxAddress:Text,
    To:Text,
    Cc:Text,
    Bcc:Text,
    Subject:Text,
    Body:Text,
    ReplyAll:Boolean,
    Importance:Text,
    Attachments:Table
    }
)

RespondToEventV2

RespondToEventV2(
 event_id,
 response,
    {
    Comment:Text,
    SendResponse:Boolean
    }
)

SendEmailV2 

SendEmailV2(
 To,
 Subject,
 Body,
    {
    From:Text,
    Cc:Text,
    Bcc:Text,
    Attachments:Table,
    ReplyTo:Text,
    Importance:Text
    }
)

SharedMailboxSendEmailV2

SharedMailboxSendEmailV2(
 MailboxAddress,
 To,
 Subject,
 Body,
    {
    Cc:Text,
    Bcc:Text,
    Attachments:Table,
    ReplyTo:Text,
    Importance:Text
    }
)

SendApprovalMail

SendApprovalMail(
 NotificationUrl,
 Message
)

SendMailWithOptions

SendMailWithOptions(
 NotificationUrl,
 Message
)

SetAutomaticRepliesSettingV2

SetAutomaticRepliesSettingV2(
    {
    automaticRepliesSetting:Record
    }
)

ContactPatchItemV2

ContactPatchItemV2(
 folder,
 id,
 givenName,
 headPhones,
    {
    id:Text,
    parentFolderId:Text,
    birthday:DateTime,
    fileAs:Text,
    displayName:Text,
    initials:Text,
    middleName:Text,
    nickName:Text,
    surname:Text,
    title:Text,
    generation:Text,
    emailAddresses:Table,
    imAddresses:Table,
    jobTitle:Text,
    companyName:Text,
    department:Text,
    officeLocation:Text,
    profession:Text,
    businessHomePage:Text,
    assistantName:Text,
    manager:Text,
    businessPhones:Table,
    mobilePhone:Text,
    homeAddress:Record,
    businessAddress:Record,
    otherAddress:Record,
    yomiComanyName:Text,
    yomiGivenName:Text,
    yomiSurname:Text,
    categories:Table,
    cangeKey:Text,
    createdDateTime:DateTime,
    lastModifiedDateTime:DateTime
    }
)

V4CalendarPatchItem

V4CalendarPatchItem(
 table,
 id,
 subject,
 start,
 end,
 timeZone,
    {
    requiredAttendees:Text,
    optionalAttendees:Text,
    resourceAttendees:Text,
    body:Text,
    location:Text,
    importance:Text,
    isAllDay:Boolean,
    recurrence:Text,
    recurrenceEnd:Text,
    numberOfOccurences:Number,
    reminderMinutesBeforeStart:Number,
    isReminderOn:Boolean,
    showAs:Text,
    responseRequested:Boolean,
    sensitivity:Text
    }
)

UpdateMyContactPhoto

UpdateMyContactPhoto(
 folder,
 id,
 file
    {
    'Content-Type':Text
    }
)

List of deprecated actions

 

Action in Power Apps	Operation ID
Create contact	ContactPostItem
Create event (V1)	CalendarPostItem
Create event (V2)	V2CalendarPostItem
Create event (V3)	V3CalendarPostItem
Delete contact	ContactDeleteItem
Delete email	DeleteEmail
Delete event	CalendarDeleteItem
Export email	ExportEmail
Find meeting times	FindMeetingTimes
Flag email	Flag
Forward an email	ForwardEmail
Get attachment	GetAttachment
Get calendar view of events (V2)	GetEventsCalendarViewV2
Get calendar view of events	GetEventsCalendarView
Get calendars	CalendarGetTables
Get contact	ContactGetItem
Get contact folders	ContactGetTables
Get contacts	ContactGetItems
Get email	GetEmail
Get emails (V2)	GetEmailsV2
Get emails	GetEmails
Get event (V1)	CalendarGetItem
Get event (V2)	V2CalendarGetItem
Get events (V1)	CalendarGetItems
Get events (V2)	V2CalendarGetItems
Get events (V3)	V3CalendarGetItems
Get mail tips for a mailbox	GetMailTips
Get room lists	GetRoomLists
Get rooms	GetRooms
Get rooms in room list	GetRoomsInRoomList
Mark as read	MarkAsRead
Mark as read or unread (V2)	MarkAsRead_V2
Move email	Move
Reply to email (V2)	ReplyToV2
Reply to email	ReplyTo
Respond to an event invite	RespondToEvent
Send an email	SendEmail
Send an email from a shared mailbox	SharedMailboxSendEmail
Set up automatic replies	SetAutomaticRepliesSetting
Update contact	ContactPatchItem
Update event (V1)	CalendarPatchItem
Update event (V2)	V2CalendarPatchItem
Update event (V3)	V3CalendarPatchItem

 

Summary

 

In this article, we have seen the Office365Outlook connector in PowerApps, the actions used to perform various activities in Office 365 Outlook calendar events and emails. We have also seen the list of available actions and a list of deprecated actions. This article mainly provides you with a quick look at the syntax of each available action and gives you a clear understanding of what you can do with that action.

 

Reference

• https://docs.microsoft.com/en-us/connectors/office365/
• https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-office365-outlook