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

Calendar

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 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. A Streaming input section is added to the card from which you can select a helper flow for streaming and adding custom extensible fields.	Dropdown	TRUE

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 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. A Streaming input section is added to the card from which you can select a helper flow for streaming and adding 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 `User Calendars` is selected from the Calendar option.	String	TRUE
Calendar ID	Unique ID of the calendar. Appears when `User Calendars` is selected from the Calendar option.	String	TRUE
Calendar	Choose a calendar. Appears when `My calendars` is selected from the Calendar option.	Dropdown	TRUE
Search
Subject	Subject of the event. Appears when `Exact Match` or `Contains` are selected from the Search By option.	String	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 `Greater Than or Equal` is selected from the Search By option.	Date and 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 `Greater Than or Equal` is selected from the Search By option.	Date and 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 `Exact Match` or `Greater Than or Equal` are selected from the Search By option.	Date and 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 `Exact Match` or `Greater Than or Equal` are selected from the Search By option.	Date and Time	FALSE
Location Display Name	Name of the location. Appears when `Exact Match` is selected from the Search By option.	String	FALSE
Importance	Indicates the importance of the event. Possible values are: `Low` `Normal` `High` Appears when `Exact Match` is selected from the Search By option.	Dropdown	FALSE
Sensitivity	Indicates the sensitivity of the event. Possible values are: `Normal` `Personal` `Private` `Confidential` Appears when `Exact Match` is selected from the Search By option.	Dropdown	FALSE
Response Requested?	`True` Indicates if a response to the event is required; otherwise, `False`. Appears when `Exact Match` is selected from the Search By option.	Boolean	FALSE
Allow New Time Proposals?	`True` if the meeting organizer allows invitees to propose a new time when responding; otherwise, `False`. Appears when `Exact Match` is selected from the Search By option.	Boolean	FALSE
Is All Day?	`True` if the event lasts all day; otherwise, `False`. Appears when `Exact Match` is selected from the Search By option.	Boolean	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 `Exact Match` is selected from the Search By option.	Boolean	FALSE
Is Cancelled?	`True` if the event has been canceled; otherwise, `False`. Appears when `Exact Match` is selected from the Search By option.	Boolean	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 `Exact Match` is selected from the Search By option.	Boolean	FALSE
Is Draft?	`True` if the user has updated the meeting in Outlook but has not 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 `Exact Match` is selected from the Search By option.	Boolean	FALSE
Created Range Start	Created start time for the time range. For example, 2021-11-04T08:10:16.5385504Z Appears when `Range` is selected from the Search By option.	Date and Time	FALSE
Created Range End	Created end time for the time range. For example, 2021-11-04T08:10:16.5385504Z Appears when `Range` is selected from the Search By option.	Date and 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 `Range` is selected from the Search By option.	Date and 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 `Range` is selected from the Search By option.	Date and Time	FALSE
Streaming
Flow	Click Choose Flow to browse and select a helper flow to which 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 displays when `Stream Matching Records` is selected from the Result Set field.	Flow	TRUE
Search Criteria
Record Limit	Specify the number of records to stream. When the Limit field is set to 0, no records are returned. When the Limit field is set to greater than 0, records greater than 0 and up the maximum number of records specified are returned. When the Limit field is empty or not selected, all records are streamed. Default value is 10 million. Valid range is 0 to 10 million. Appears when Stream Matching Records is selected from the Result Set option.	Number	FALSE

Output

Field	Definition	Type
Result
Events	List of events. Appears when `First 200 Matching Records` is selected from the Result Set option.	List of Strings
Event ID	Unique ID of the event.	String
Subject	Subject of the event.	String
Body Preview	Preview of the file's content in the view's reading pane.	String
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 and Time
Time Zone	Represents a time zone when the event started. For example, Pacific Standard Time.	String
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 and Time
Time Zone	Represents a time zone when the event ended. For example, Pacific Standard Time.	String
Location
Display Name	Name associated with the location. Appears when one location is returned.	String
Location URI	URI representing the location.	String
Location Type	Type of location. Appears when one location is returned.	String
Unique ID	Unique identifier of the event. Appears when one location is returned.	String
Unique ID Type	Unique identifier of the type. Appears when one location is returned.	String
Street	Street name of the location. Appears when one location is returned.	String
City	City of the location. Appears when one location is returned.	String
State	State of the location. Appears when one location is returned.	String
Country or Region	List of countries and regions in two-letter format specified by ISO 3166-2. Appears when `First Matching Record` is selected from the Result Set option.	String
Postal Code	Postal Code of the address. Appears when one location is returned.	String
Latitude	Latitude of the location. Appears when one location is returned.	String
Longitude	Longitude of the location. Appears when one location is returned.	String
Attendees
Type	Attendee type.	String
Status		Object
Response	Response type.	String
Time	The date and time that the response was returned. It uses ISO 8601 format and is always in UTC time. For example, midnight UTC on Jan 1, 2014 is 2014-01-01T00:00:00Z	Date and Time
Email Address
Name	Display name of the person or entity.	String
Address	Email address of the person or entity.	String
Organizer
Email Address	Email address of the organizer.	String
Name	Display name of the organizer.	String
Address	Address of the organizer.	String
Records Streamed	Number of records streamed in a streaming flow. Appears when Stream Matching Records is selected from the Result Set option.	Number

Search Events

Options

Input

Output

Related topics