Search Emails

Search emails in Office 365 Mail.

Options

Field	Definition	Type	Required
Mail	Determines the type of user mail: `My Mail`: owned by the connected user. `User Mail`: user shared or delegated with the connected user.	Dropdown	TRUE
Result Set	Specifies the number of emails returned in the response. Choose a method to filter search results: `First Matching Record`: Returns the first record that matches. `First 200 Matching Records`: Returns the first 200 matching records. `Stream Matching Records`: Passes all matching records from your parent flow to a helper flow. Selecting this option adds a Streaming input section to the card where you can select a helper flow for streaming and add custom extensible fields.	Dropdown	TRUE
Search By	Specifies how to compare input text values. Searches all text fields. Choose an operator to search by: `Exact Match`: returns emails when the search fully matches the entered text/number values. For example: search for all subjects that contain Important. `Contains`: returns emails with partial matching of entered text/number values. For example: search in the Sender field for words that contain Smith. `Starts With`: returns emails when the search starts with the entered text/number values.	Dropdown	TRUE
Date Filter	Specifies the date of the email in the response. Searches all text fields. Choose an operator to search by: `Greater Than`: returns emails that were sent or received in a time period that is greater than the Start Date Filter fields. For example, search for all emails where the date is greater than 1/1/2022. `Less Than`: returns emails that were sent or received in a time period that is less than the End Date Filter fields. For example, search in the End field for a value less than 3/19/2022. `Range`: returns email that are within a specific date range for date values. `None`: Date searches are not used.	Dropdown	TRUE

Note:

To learn how to return a large number of records, see Set up the stream matching option with a helper flow.

Input

Field	Definition	Type	Required
User
User ID or Username	User ID of the email's attachment that is uploaded. For example, `john.doe@somedomain.com`. This could be the user's email address, but this is not true in all cases. This property cannot contain accent characters. Only the following characters are allowed A - Z, a - z, 0 - 9, ' . - _ ! # ^ ~. Appears when `User Mail` is selected from the Mail option.	Text	TRUE
Search	Appears when `Contains` is selected from the Search By option unless otherwise specified.
Subject	Subject of the message. Appears when `Starts With` and `Contains` are selected from the Search By option.	Text	FALSE
Body	Body of the message. It can be in HTML or text format. Searching the body of the message using text is supported. Searching the body of the message using HTML is not supported. Appears when `Starts With` and `Contains` are selected from the Search By option.	Text	FALSE
From	Owner of the mailbox from which the message is sent.	Text	FALSE
Sender	Account that is actually used to generate the message. Does not display when `None` is selected from the Search By option.	Text	FALSE
Has Attachments?	`True` if the message has attachments; otherwise, `False`. To verify the existence of inline attachments, parse the body property to look for a src attribute. For example, <IMG src="cid:image001.jpg@01D26CD8.6C05F070">. Appears when `Exact Match` is selected from the Search By option. Note: This field doesn't include inline attachments. If a message contains only inline attachments, this field is False.	True/False	FALSE
Importance	Importance of the message. The possible values are: `Low` `Normal` `High` Appears when `Exact Match` is selected from the Search By option.	Text	FALSE
Is Read?	`True` if the message has been read; otherwise `False`. Appears when `Exact Match` is selected from the Search By option.	True/False	FALSE
Is Draft?	`True` if the message is a draft (hasn't been sent); otherwise, `False`. Appears when `Exact Match` is selected from the Search By option.	True/False	FALSE
Flag Status	Status for follow-up for an item. Possible values are: `Not Flagged` `Complete` `Flagged` Appears when `Exact Match` is selected from the Search By option.	Object	FALSE
Is Delivery Receipt Requested?	`True` if a read receipt is requested for the message; otherwise `False`. Appears when `Exact Match` is selected from the Search By option.	True/False	FALSE
Is Read Receipt Requested?	`True` if a read receipt is requested for the message; otherwise `False`. Appears when `Exact Match` is selected from the Search By option.	True/False	FALSE
Start Date Filter	Appears when any of the following `Greater Than` or `Range` are selected from the Date Filter option.
Created Date Time	Date and time the message was created. For example, 2020-01-01T00:00:00Z.	Date & Time	FALSE
Last Modified Date Time	Date and time the message was last changed. For example, 2020-01-01T00:00:00Z.	Date & Time	FALSE
Receive Date Time	Date and time the message was received. For example, 2020-01-01T00:00:00Z.	Date & Time	FALSE
Sent Date Time	Date and time the message was sent. For example, 2020-01-01T00:00:00Z.	Date & Time	FALSE
End Date Filter	Appears when any of the following `Range` or `Less Than` are selected from the Date Filter option.
Created Date Time	Date and time the message was created. For example, 2020-01-01T00:00:00Z.	Date & Time	FALSE
Last Modified Date Time	Date and time the message was last changed. For example, 2020-01-01T00:00:00Z.	Date & Time	FALSE
Receive Date Time	Date and time the message was received. For example, 2020-01-01T00:00:00Z.	Date & Time	FALSE
Sent Date Time	Date and time the message was sent. For example, 2014-01-01T00:00:00Z.	Date & Time	FALSE
Search Criteria
Record Limit	Specify the number of records to stream. When the `Limit` field is set to `0`, the stream returns no records. When the `Limit` field is set to greater than `0`, the stream returns up to the maximum number specified. When the `Limit` field is empty, null, or not selected, the stream returns all records. The default value is `10000000` (10 million). The valid range is `0` to `10000000`. This field appears when you select `Stream Matching Records` from the Result Set option.	Number	FALSE
Streaming
Flow	Click Choose Flow to browse and select a helper flow where the search results will be streamed, then click Choose to confirm. Optionally, click the empty field under Click or drop here to create and add custom extensible fields that pass data to the helper flow. These fields are added as key/value pairs under the State output object in the helper flow.	Flow	TRUE

Output

Note:

Input fields that are left empty are ignored.

Field	Definition	Type
Result	Appears when `First Matching Record` or `200 Matching Records` are selected from the Result Set option unless otherwise specified.
ID	Unique ID of the message.	Text
Subject	Subject of the email.	Text
Body Preview	First 255 characters of the message body in text format.	Text
Body	Body of the message. It can be in HTML or text format. Find out about safe HTML in a message body.	Object
Content Type	Content type of the message.	Text
Content	Content of the message.	Text
Created Date Time	Date and time when the attachment was last created. For example, 2020-01-01T00:00:00Z.	Date & Time
Last Modified Date Time	Date and time when the attachment was last modified. For example, 2020-01-01T00:00:00Z.	Date & Time
Change Key	Version of the message.	Text
Categories	Categories associated with the message.	List of Text
Received Date Time	Date and time the message was received. For example, 2020-01-01T00:00:00Z.	Date & Time
Sent Date Time	Date and time the message was sent. For example, 2020-01-01T00:00:00Z.	Date & Time
Has Attachments?	`True` if the message has attachments; otherwise, `False`. To verify the existence of inline attachments, parse the body property to look for a src attribute. For example, <IMG src="cid:image001.jpg@01D26CD8.6C05F070">. Note: This field doesn't include inline attachments. If a message contains only inline attachments, this field is False.	True/False
Internet Message ID	Message ID in the format specified by RFC2822.	Text
Importance	Importance of the message. The possible values are: `Low` `Normal` `High`	Text
Parent Folder ID	Unique identifier for the message's parent mail folder.	Text
Conversation ID	Unique identifier to which the conversation of the email belongs.	Text
Conversation Index	Indicates the position of the message within the conversation.	Text
Is Delivery Receipt Requested?	`True` if a read receipt is requested for the message; otherwise `False`.	True/False
Is Read Receipt Requested?	`True` if a read receipt is requested for the message; otherwise `False`.	True/False
Is Read?	`True` if the message has been read; otherwise `False`.	True/False
Is Draft?	`True` if the message is a draft and hasn't been sent; otherwise, `False`.	True/False
Web Link	URL to open the message in Outlook on the web. You can append an ispopout argument to the end of the URL to change how the message is displayed. If ispopout is not present or if it is set to 1, then the message is shown in a popout window. If ispopout is set to 0, then the browser will show the message in the Outlook on the web review pane. The message will open in the browser if you are logged in to your mailbox via Outlook on the web. You will be prompted to login if you are not already logged in with the browser. This URL cannot be accessed from within an iFrame.	Text
Sender	Account that is actually used to generate the message. In most cases, this value is the same as the from property. You can set this property to a different value when sending a message from a shared mailbox, for a shared calendar, or as a delegate. In any case, the value must correspond to the actual mailbox used. Find out more about setting the from and sender properties of a message. In most cases, this value is the same as the From property. You can set this property to a different value when sending a message from a shared mailbox, for a shared calendar, or as a delegate. In any case, the value must correspond to the actual mailbox used.	Object
Email Address	Recipient's email address.	Object
Name	Name of the recipient.	Text
Address	Email address of the recipient.	Text
From	Email address of the sender of the email. In most cases, this value is the same as the sender property, except for sharing or delegation scenarios. The value must correspond to the actual mailbox used.	Object
Email Address	Recipient's email address.	Object
Name	Name of the recipient.	Text
Address	Email address of the recipient.	Text
To Recipients	To: recipients for the message.	List of Objects
Email Address	Recipient's email address.	Object
Name	Name of the recipient.	Text
Address	Email address of the recipient.	Text
CC Recipients	Cc: recipients for the message.	List of Objects
Email Address	Recipient's email address.	Object
Name	Name of the recipient.	Text
Address	Email address of the recipient.	Text
BCC Recipients	Bcc: recipients for the message.	List of Objects
Email Address	Recipient's email address.	Object
Name	Name of the recipient.	Text
Address	Email address of the recipient.	Text
Reply To	Email addresses to use when replying.	List of Text
Flag	Flag value that indicates the status, start date, due date, or completion date for the message.	Text
Attachments	Attachment for the email.	List of Objects
ID	Unique ID of the attachment.	Text
Name	Name representing the text that is displayed below the icon representing the embedded attachment. This does not need to be the actual file name.	Text
Last Modified Date an Time	Date and time that the attachment was modified.	Date & Time
Content Type	Content type of the attachment.	Text
Size	Size in bytes of the attachment.	Number
Is Inline?	`Yes` if attachment is inline; otherwise `False`.	True/False
Records Streamed	Number of records streamed in a streaming flow. This field appears when you select `Stream Matching Records` from the Result Set option.	Number