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

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.

    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 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, 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.

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.

This field appears when you select Stream Matching Records from the Result Set option.

Number

Related topics

Office 365 Calendar connector

Workflow elements

Guidance for Office 365 Calendar connector

Microsoft Graph Rest API