Groups
Represents the groups created automatically when a new plan is initiated, serving as the foundational organizational unit for tasks and plans.
Table Specific Information
Select
The add-in uses the Microsoft Planner API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.
If Scope = NoAdminConsent: Lists data related to the groups that the user is a member of.
If Scope = AdminConsent: Lists all data related to groups.
- Id supports the '=' operator.
For example, the following query is processed server-side:
SELECT * FROM Groups WHERE Id = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier for the group, used as a primary key across systems. |
| deletedDateTime | Datetime | The timestamp indicating when the group was deleted, if applicable. |
| allowExternalSenders | Bool | Specifies whether individuals outside the organization can send messages to the group. |
| assignedLabels | String | A list of sensitivity label pairs applied to the group for classification and compliance. |
| assignedLicenses | String | A list of licenses assigned to the group, specifying its entitlements. |
| autoSubscribeNewMembers | Bool | Indicates whether new members are automatically subscribed to receive group email notifications. |
| classification | String | Defines the classification level for the group, such as confidential or public. |
| createdDateTime | Datetime | The date and time when the group was created. |
| description | String | An optional text description providing additional context about the group's purpose. |
| displayName | String | The display name of the group, commonly shown in user interfaces. |
| expirationDateTime | Datetime | The date and time when the group is set to expire, if applicable. |
| groupTypes | String | Indicates the type of group (for example, security or Microsoft 365) and its membership type. |
| hasMembersWithLicenseErrors | Bool | Indicates whether any members have licensing errors due to group-based license assignments. |
| hideFromAddressLists | Bool | Indicates whether the group is hidden from address lists in the organization. |
| hideFromOutlookClients | Bool | Specifies if the group is hidden from being displayed in Outlook clients. |
| isArchived | Bool | Indicates if the group is archived, typically for read-only access in associated teams. |
| isAssignableToRole | Bool | Specifies whether the group can be assigned to roles in Microsoft Entra (formerly Azure AD). |
| isSubscribedByMail | Bool | Indicates if the signed-in user is subscribed to receive email conversations from the group. |
| licenseProcessingState_state | String | Represents the current processing state of group-based license assignments. |
| String | The primary email address associated with the group. | |
| mailEnabled | Bool | Specifies whether the group is enabled to send and receive emails. |
| mailNickname | String | The mail alias for the group, often used as part of the email address. |
| membershipRule | String | The dynamic membership rule that defines group membership criteria. |
| membershipRuleProcessingState | String | Indicates whether the dynamic membership rules are actively being processed. |
| onPremisesDomainName | String | The domain name of the group as synchronized from an on-premises directory. |
| onPremisesLastSyncDateTime | Datetime | The date and time of the last synchronization with the on-premises directory. |
| onPremisesNetBiosName | String | The NetBIOS name of the group as synchronized from the on-premises directory. |
| onPremisesProvisioningErrors | String | Details of any provisioning errors encountered during synchronization from the on-premises directory. |
| onPremisesSamAccountName | String | The software asset management (SAM) account name of the group as synchronized from the on-premises directory. |
| onPremisesSecurityIdentifier | String | The security identifier (SID) of the group as synchronized from the on-premises directory. |
| onPremisesSyncEnabled | Bool | Indicates whether the group is actively synced with the on-premises directory. |
| preferredDataLocation | String | The preferred data residency location for the group's content. |
| preferredLanguage | String | The preferred language setting for the group, used for communication and display. |
| proxyAddresses | String | A list of email addresses associated with the group that redirect to the group mailbox. |
| renewedDateTime | Datetime | The timestamp indicating when the group was last renewed. |
| securityEnabled | Bool | Specifies whether the group is a security group used for access control. |
| securityIdentifier | String | The security identifier (SID) uniquely assigned to the group. |
| serviceProvisioningErrors | String | Details of any errors encountered during service provisioning for the group. |
| theme | String | The color theme associated with the group, used in user interfaces. |
| uniqueName | String | A unique identifier or alias that can be used as an alternate key for the group. |
| unseenCount | Int | The number of new posts in conversations since the user last accessed the group. |
| visibility | String | Defines the group's join policy and visibility settings (for example, public or private). |
| calendar_id | String | The unique identifier of the group's calendar. |
| createdOnBehalfOf_id | String | The unique identifier of the user or application that created the group. |
| drive_id | String | The unique identifier of the group's associated drive. |
| onenote_id | String | The unique identifier of the group's OneNote notebook is read-only. |
| photo_id | String | The unique identifier of the group's profile photo. |
| planner_id | String | The unique identifier of the group's associated planner. |
| team_id | String | The unique identifier of the Microsoft Teams entity associated with the group. |