Search Events

Search for the events from an authorized user or for another user's calendar in Office 365 Calendar.

Options

Field Definition Type Required

Field	Definition	Type	Required
Calendar	Choose the calendar type: `My Calendars`: Calendars owned by a connected user. `User Calendars`: User calendar shared or delegated with a connected user.	Dropdown	TRUE
Search By	Choose a method to search by: `Exact Match`: search based on exact matching. `Contains`: search based on martial matching. `Greater Than or Equal`: search for a greater or equal date. `Range`: search for events that are in a date range.	Dropdown	TRUE
Result Set	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

Calendar

Choose the calendar type:

My Calendars: Calendars owned by a connected user.
User Calendars: User calendar shared or delegated with a connected user.

Dropdown

TRUE

Search By

Choose a method to search by:

Exact Match: search based on exact matching.
Contains: search based on martial matching.
Greater Than or Equal: search for a greater or equal date.
Range: search for events that are in a date range.

Dropdown

TRUE

Result Set

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

Input

Field	Definition	Type	Required
Search At
User ID or Username	Unique ID of the user or username. Appears when you select `User Calendars` for the Calendar option.	Text	TRUE
Calendar ID	Unique ID of the calendar. Appears when you select `User Calendars` for the Calendar option.	Text	TRUE
Calendar	Choose a calendar. Appears when you select `My Calendars` for the Calendar option.	Dropdown	TRUE
Search
Subject	Subject of the event. Appears when you select `Exact Match` or `Contains` for the Search By option.	Text	FALSE
Created	Date and time information using ISO 8601 format and is always in UTC time. For example, 2021-11-04T08:10:16.5385504Z Appears when you select `Greater Than or Equal` for the Search By option.	Date & Time	FALSE
Last Modified	Date and time information using ISO 8601 format and is always in UTC time. For example, 2021-11-04T08:10:16.5385504Z Appears when you select `Greater Than or Equal` for the Search By option.	Date & Time	FALSE
Start	Single point of time for the start of the event in a combined date and time representation {date}T{time}. For example, 2021-11-10T06:00:00.0000000. Appears when you select `Exact Match` or `Greater Than or Equal` for the Search By option.	Date & Time	FALSE
End	Single point of time for the end of the event in a combined date and time representation {date}T{time}. For example, 2021-11-10T06:00:00.0000000. Appears when you select `Exact Match` or `Greater Than or Equal` for the Search By option.	Date & Time	FALSE
Location Display Name	Name of the location. Appears when you select `Exact Match` for the Search By option.	Text	FALSE
Importance	Indicates the importance of the event. `Low` `Normal` `High` Appears when you select `Exact Match` for the Search By option.	Dropdown	FALSE
Sensitivity	Indicates the sensitivity of the event. `Normal` `Personal` `Private` `Confidential` Appears when you select `Exact Match` for the Search By option.	Dropdown	FALSE
Response Requested?	`True` Indicates if a response to the event is required. Otherwise `False`. Appears when you select `Exact Match` for the Search By option.	True/False	FALSE
Allow New Time Proposals?	`True` if the meeting organizer allows invitees to propose a new time when responding. Otherwise `False`. Appears when you select `Exact Match` for the Search By option.	True/False	FALSE
Is All Day?	`True` if the event lasts all day. Otherwise `False`. Appears when you select `Exact Match` for the Search By option.	True/False	FALSE
Has Attachments?	`True` if the message has attachments. Otherwise, `False`. This property doesn't include inline attachments, so if a message contains only inline attachments, this property is `False`. Appears when you select `Exact Match` for the Search By option.	True/False	FALSE
Is Cancelled?	`True` if the event has been canceled. Otherwise `False`. Appears when you select `Exact Match` for the Search By option.	True/False	FALSE
Is Organizer?	`True` if the calendar owner (specified by the owner property of the calendar) is the organizer of the event (specified by the organizer property of the event). Otherwise `False`. This also applies if a delegate organized the event on behalf of the owner. Appears when you select `Exact Match` for the Search By option.	True/False	FALSE
Is Draft?	`True` if the user has updated the meeting in Outlook but hasn't sent the updates to attendees. Set to `False` if all changes have been sent, or if the event is an appointment without any attendees. Appears when you select `Exact Match` for the Search By option.	True/False	FALSE
Created Range Start	Created start time for the time range. For example, 2021-11-04T08:10:16.5385504Z Appears when you select `Range` for the Search By option.	Date & Time	FALSE
Created Range End	Created end time for the time range. For example, 2021-11-04T08:10:16.5385504Z Appears when you select `Range` for the Search By option.	Date & Time	FALSE
Last Modified Range Start	Date and time when the range start was last modified. For example, 2021-11-04T08:10:16.5385504Z Appears when you select `Range` for the Search By option.	Date & Time	FALSE
Last Modified Range End	Date and time when the range end was last modified. For example, 2021-11-04T08:10:16.5385504Z Appears when you select `Range` for the Search By option.	Date & Time	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. This field appears when you select `Stream Matching Records` from the Result Set option.	Flow	TRUE
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

Output

Field	Definition	Type
Result
Events	List of events. This field appears when you select `First 200 Matching Records` from the Result Set option.	List of Text
Event ID	Unique ID of the event.	Text
Subject	Subject of the event.	Text
Body Preview	Preview of the file's content in the view's reading pane.	Text
Start
Date Time	Single point of time in a combined date and time representation {date}T{time}. For example, 2017-08-29T04:00:00.0000000.	Date & Time
Time Zone	Represents a time zone when the event started. For example, Pacific Standard Time.	Text
End
Date Time	A single point of time for the event end in a combined date and time representation {date}T{time}. For example, 2017-08-29T04:00:00.0000000.	Date & Time
Time Zone	Represents a time zone when the event ended. For example, Pacific Standard Time.	Text
Location
Display Name	Name associated with the location. Appears when one location is returned.	Text
Location URI	URI representing the location.	Text
Location Type	Type of location. Appears when one location is returned.	Text
Unique ID	Unique identifier of the event. Appears when one location is returned.	Text
Unique ID Type	Unique identifier of the type. Appears when one location is returned.	Text
Street	Street name of the location. Appears when one location is returned.	Text
City	City of the location. Appears when one location is returned.	Text
State	State of the location. Appears when one location is returned.	Text
Country or Region	List of countries and regions in two-letter format specified by ISO 3166-2. This field appears when you select `First Matching Record` from the Result Set option.	Text
Postal Code	Postal Code of the address. Appears when one location is returned.	Text
Latitude	Latitude of the location. Appears when one location is returned.	Text
Longitude	Longitude of the location. Appears when one location is returned.	Text
Attendees
Type	Attendee type.	Text
Status		Object
Response	Response type.	Text
Time	The date and time that the response was returned. It uses the ISO 8601 format and is always in UTC time. For example, midnight UTC on Jan 1, 2014 is 2014-01-01T00:00:00Z	Date & Time
Email Address
Name	Display name of the person or entity.	Text
Address	Email address of the person or entity.	Text
Organizer
Email Address	Email address of the organizer.	Text
Name	Display name of the organizer.	Text
Address	Address of the organizer.	Text
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