Groups
It is automatically created to support a plan that is created.
Table Specific Information
Select
The add-in will use 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, List the data related to the groups that the user is a member of.
If Scope = AdminConsent, List all the data related to groups.
- Id supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Groups WHERE Id = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the group. |
| deletedDateTime | Datetime | Timestamp of when the group was deleted. |
| allowExternalSenders | Bool | Typically used for people external to the organization that can send messages to the group. |
| assignedLabels | String | Specifies list of sensitivity label pairs associated with a group. |
| assignedLicenses | String | Specifies licenses that are assigned to the group. |
| autoSubscribeNewMembers | Bool | Typically used for new members added to the group that are autosubscribed to receive email notifications. |
| classification | String | Specifies classification for the group. |
| createdDateTime | Datetime | Specifies timestamp of when the group was created. |
| description | String | An optional description for the group. |
| displayName | String | The display name for the group. |
| expirationDateTime | Datetime | Timestamp of when the group is set to expire. |
| groupTypes | String | Specifies the group type and its membership. |
| hasMembersWithLicenseErrors | Bool | Specifies members in this group that have license errors from its group-based license assignment. |
| hideFromAddressLists | Bool | This property is true if the group is not displayed in certain parts. |
| hideFromOutlookClients | Bool | The label Hide from Outlook Clients corresponds to this field. |
| isArchived | Bool | Typically used for groups associated with a team and whether the team is in read-only mode. |
| isAssignableToRole | Bool | Specifies whether a group can be assigned to a Microsoft Entra role. |
| isSubscribedByMail | Bool | Specifies the signed-in user that is subscribed to receive email conversations. |
| licenseProcessingState_state | String | Specifies the status of the group license assignment to all group members. |
| String | The mail for the group. | |
| mailEnabled | Bool | Specifies whether the group is mail-enabled. |
| mailNickname | String | Specifies the mail alias for the group. |
| membershipRule | String | Specifies the rule for members of this group. |
| membershipRuleProcessingState | String | Specifies whether the dynamic membership processing is on or paused. |
| onPremisesDomainName | String | Specifies the on-premises domain. |
| onPremisesLastSyncDateTime | Datetime | Specifies the on-premises last sync date time. |
| onPremisesNetBiosName | String | Specifies the on-premises netBios name synchronized from the on-premises directory. |
| onPremisesProvisioningErrors | String | Specifies the on-premises provisioning errors. |
| onPremisesSamAccountName | String | Specifies the on-premises SAM account name synchronized from the on-premises directory. |
| onPremisesSecurityIdentifier | String | Specifies the on-premises security identifier for the group that is synchronized from on-premises to the cloud. |
| onPremisesSyncEnabled | Bool | Specifies whether the group is currently synced from an on-premises directory. |
| preferredDataLocation | String | Specifies the preferred date location. |
| preferredLanguage | String | The preferred language for a group. |
| proxyAddresses | String | Specifies the email addresses for the group that direct to the same group mailbox. |
| renewedDateTime | Datetime | Timestamp of when the group was last renewed. |
| securityEnabled | Bool | Specifies whether the group is a security group. |
| securityIdentifier | String | Specifies the security identifier of the group. |
| serviceProvisioningErrors | String | Specifies service provisioning errors. |
| theme | String | Specifies a group's color theme. |
| uniqueName | String | The unique identifier that can be assigned to a group and used as an alternate key. |
| unseenCount | Int | Specifies the count of conversations that have received new posts since the user last visited the group. |
| visibility | String | Specifies the group join policy and group content visibility for groups. |
| calendar_id | String | Unique identifier of the calendar. |
| createdOnBehalfOf_id | String | Unique identifier of the user (or application) that created the group. |
| drive_id | String | Unique identifier of the drive. |
| onenote_id | String | Unique identifier of the onenote. Read-only |
| photo_id | String | Unique identifier of the group's profile photo. |
| planner_id | String | Unique identifier of the planner. |
| team_id | String | Unique identifier of the team associated with the group. |