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