Send An Email Notification Using Outlook.com Connector In PowerApps

Introduction

In my previous article Send An Email Notification Using Mail Connector In PowerApps we have seen the Mail Connector in action.

In this article, let's have a look at the Outlook.com connector to send email notifications in Power Apps without using Power Automate Flow. You will get to see the different actions that you can call in Power Apps. There are few actions that are deprecated by Microsoft and will be eventually removed. I will list down the deprecated actions in this article, consider replacing deprecated actions with the latest release of actions in your applications.

Most of the actions of the Outlook.com connector are circled around all things events in a calendar along with sending emails with and without attachments.

Just to be clear, in this article we will see Outlook.com connector along with its general available actions (excluding deprecated actions) in Power Apps. There are triggers and actions available for Outlook.com connector in Power Automate which would possibly be another article series of "Send emails using the different connector in Power Automate". Stay tuned!

Now, let's get started.

Outlook.com Connector

As per Microsoft documentation (refer to Reference section for the link to this documentation), on the addition of Outlook.com connector, it will always ask for access to an Outlook mailbox that has the REST API enabled. So make sure you have this pre-requisite in place.

Let me quote an important note by Microsoft for enterprise accounts:

This connector is no longer supporting enterprise accounts due to security policies. Existing connections will continue to work for some time, but new connections are not allowed. Enterprise accounts should use the Office 365 Outlook connector which has the same functionality as the Outlook.com connector. While we understand switching connectors is not trivial, this is necessary to allow better security controls for our users.

With that said, another point to note on throttling limit for Outlook.com connector is it's 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	ContactPostItem
Create event	V3CalendarPostItem
Delete contact	ContactDeleteItem
Delete email	DeleteEmail
Delete event	CalendarDeleteItem
Flag email	Flag
Forward an email	ForwardEmail
Get attachment	GetAttachment
Get calendar view of events (V2)	GetEventsCalendarViewV2
Get calendars	CalendarGetTables
Get contact	ContactGetItem
Get contact folders	ContactGetTables
Get contacts	ContactGetItems
Get email	GetEmail
Get emails (V2)	GetEmailsV2
Get event	V2CalendarGetItem
Get events	V3CalendarGetItems
Mark as read	MarkAsRead
Move email	Move
Reply to email (V3)	ReplyToV3
Respond to an event invite	RespondToEvent
Send an email (V2)	SendEmailV2
Send approval email	SendApprovalEmail
Send email with options	SendMailWithOptions
Update contact	ContactPatchItem
Update event (V3)	V3CalendarPatchItem

Syntax of each action listed in Table 1

ContactPostItem

ContactPostItem(
table,
GivenName,
HomePhones,
{
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,
MobilePhone1:Text,
HomeAddress:Record,
BusinessAddress:Record,
OtherAddress:Record,
YomiCompanyName:Text,
YomiGivenName:Text,
YomiSurname:Text,
Categories:Table,
ChangeKey:Text,
DateTimeCreated:DateTime,
DateTimeLastModified:DateTime
}
)

V3CalendarPostItem

V3CalendarPostItem(
table,
Subject,
Start,
End,
{
TimeZone:Text,
RequiredAttendees:Text,
OptionalAttendees:Text,
ResourceAttendees:Text,
Body:Text,
Location:Text,
Importance:Text,
IsAllDay:Boolean,
Recurrence:Text,
RecurrenceEnd:DateTime,
NumberOfOccurrences:Number,
Reminder:Number,
ShowAs:Text,
ResponseRequested:Boolean
}
)

ContactDeleteItem

ContactDeleteItem(
table,
id
)

DeleteEmail

DeleteEmail(
messageId
)

CalendarDeleteItem

CalendarDeleteItem(
table,
id
)

Flag

Flag(
messageId
)

ForwardEmail

ForwardEmail(
message_id,
ToRecipients,
{
Comment:Text
}
)

GetAttachment

GetAttachment(
messageId,
attachmentId
)

GetEventsCalendarViewV2

GetEventsCalendarViewV2(
calendarId,
startDateTimeOffset,
endDateTimeOffset,
{
'$filter':Text,
'$orderby':Text,
'$top':Number,
'$skip':Number,
search:Text
}
)

CalendarGetTables

CalendarGetTables()

ContactGetItem

ContactGetItem(
table,
Id
)

ContactGetTables

ContactGetTables()

ContactGetItems

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

GetEmail

GetEmail(
messageId,
{
includeAttachments:Boolean
}
)

GetEmailsV2

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

V2CalendarGetItem

V2CalendarGetItem(
table,
id
)

V3CalendarGetItems

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

MarkAsRead

MarkAsRead(
messageId
)

Move

Move(
messageId,
folderPath
)

ReplyToV3

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

RepondToEvent

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

SendEmailV2

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

SendApprovalEmail

SendApprovalEmail(
NotificationUrl,
Message
)

SendMailWithOptions

SendMailWithOptions(
NotificationUrl,
Message
)

ContactPatchItem

ContactPatchItem(
table,
id,
GivenName,
HomePhones,
{
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,
MobilePhone1:Text,
HomeAddress:Record,
BusinessAddress:Record,
OtherAddress:Record,
YomiCompanyName:Text,
YomiGivenName:Text,
YomiSurname:Text,
Categories:Table,
ChangeKey:Text,
DateTimeCreated:DateTime,
DateTimeLastModified:DateTime
}
)

V3CalendarPatchItem

V3CalendarPatchItem(
table,
id,
Subject,
Start,
End,
{
TimeZone:Text,
RequiredAttendees:Text,
OptionalAttendees:Text,
ResourceAttendees:Text,
Body:Text,
Location:Text,
Importance:Text,
IsAllDay:Boolean,
Recurrence:Text,
RecurrenceEnd:DateTime,
NumberOfOccurrences:Number,
Reminder:Number,
ShowAs:Text,
ResponseRequested:Boolean
}
)

List of deprecated actions

Action in Power Apps	Operation ID
Create event (V1)	CalendarPostItem
Create event (V2)	V2CalendarPostItem
Get calendar view of events	GetEventsCalendarView
Get emails	GetEmails
Get event (V1)	CalendarGetItem
Get events (V1)	CalendarGetItems
Get events (V2)	V2CalendarGetItems
Reply to email (V2)	ReplyToV2
Reply to email	ReplyTo
Send an email	SendEmail
Update event (V1)	CalendarPatchItem
Update event (V2)	V2CalendarPatchItem

Summary

In this article, we have seen the Outlook.com connector in PowerApps, the actions used to perform various activities in 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.

References

https://docs.microsoft.com/en-us/connectors/outlook/