Groups
It is automatically created to support a plan that is created.
Table Specific Information
Select
The 本製品 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 本製品.
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. |