Users
Tracks user-specific task views and preferences, enabling personalized task management experiences.
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.
- Id supports the '=' operator.
For example, the following query is processed server-side:
SELECT * FROM Users WHERE UserId = '9523f1-aa0-4fe17-a9w7b-6860618adf'
Columns
| Name | Type | Description |
| UserId [KEY] | String | Unique identifier assigned to each user in the system. |
| aboutMe | String | A brief personal description provided by the user, visible in their profile. |
| accountEnabled | Bool | Indicates whether the user's account is active and can be used for sign-in. |
| ageGroup | String | Specifies the age group classification of the user, often for compliance purposes. |
| assignedLicenses | String | A list of licenses assigned to the user, including those inherited through group memberships. |
| assignedPlans | String | Details of service plans that are enabled for the user. |
| authorizationInfo_certificateUserIds | String | A collection of certificate user IDs associated with authorization information for this user. |
| birthday | Datetime | The user's date of birth, if provided. |
| businessPhones | String | The phone numbers listed as business contact numbers for the user. |
| city | String | The city where the user is currently located or associated with. |
| companyName | String | The name of the company or organization the user belongs to. |
| consentProvidedForMinor | String | Indicates whether consent was obtained for processing data related to a minor. |
| country | String | The country or region where the user resides. |
| createdDateTime | Datetime | The timestamp when the user's account was created in the directory. |
| creationType | String | Defines how the user account was created, for example, via manual input, synchronization, or automation. |
| customSecurityAttributes | String | A customizable set of attributes for security-specific configurations assigned to the user. |
| department | String | The department or organizational unit where the user works. |
| deviceEnrollmentLimit | Int | The maximum number of devices the user is allowed to enroll. |
| displayName | String | The name displayed in the organization's address book for this user. |
| employeeHireDate | Datetime | The user's start date in their current role or organization. |
| employeeId | String | A unique identifier assigned to the user by their employer. |
| employeeLeaveDateTime | Datetime | The date and time when the user is expected to leave or has left the organization. |
| employeeOrgData_costCenter | String | The cost center associated with the user's organizational data. |
| employeeOrgData_division | String | The division or sub-unit within the organization associated with the user. |
| employeeType | String | Specifies the user's role type, such as full-time, part-time, or contractor. |
| externalUserState | String | Indicates the status of the invited user's account, for example, pending acceptance. |
| externalUserStateChangeDateTime | Datetime | The last timestamp when the external user state was updated. |
| faxNumber | String | The fax number associated with the user. |
| givenName | String | The user's first name or given name. |
| hireDate | Datetime | The date the user was hired by the organization. |
| identities | String | List of identity options (for example, email or username) the user can use to sign in. |
| imAddresses | String | The user's instant messaging (IM) or Voice over Internet Protocol (VoIP) addresses. |
| interests | String | A list of topics or areas of interest specified by the user. |
| isResourceAccount | Bool | Indicates whether this account is used as a resource account; reserved for future use. |
| jobTitle | String | The user's official job title or role in the organization. |
| lastPasswordChangeDateTime | Datetime | The most recent date and time the user's password was changed or set. |
| legalAgeGroupClassification | String | Defines the user's age group classification for compliance or legal purposes. |
| licenseAssignmentStates | String | Details of the state of license assignments for the user. |
| String | The user's primary email address used for communication. | |
| mailboxSettings_archiveFolder | String | The default folder used for archiving mail items. |
| mailboxSettings_automaticRepliesSetting_externalAudience | String | Specifies the audience for automatic reply messages sent externally. |
| mailboxSettings_automaticRepliesSetting_externalReplyMessage | String | The custom message sent as an automatic reply to external senders. |
| mailboxSettings_automaticRepliesSetting_internalReplyMessage | String | The custom message sent as an automatic reply to internal senders. |
| mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_dateTime | String | The scheduled end date and time for automatic replies. |
| mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_timeZone | String | The time zone for the scheduled end of automatic replies. |
| mailboxSettings_automaticRepliesSetting_status | String | The current status of the automatic replies setting. |
| mailboxSettings_dateFormat | String | The date format preference for the user's mailbox. |
| mailboxSettings_delegateMeetingMessageDeliveryOptions | String | Options for delivery of delegate meeting messages. |
| mailboxSettings_language_displayName | String | The display name for the user's preferred mailbox language. |
| mailboxSettings_language_locale | String | The locale setting for the user's mailbox language. |
| mailboxSettings_timeFormat | String | The preferred time format for the user's mailbox. |
| mailboxSettings_timeZone | String | The time zone associated with the user's mailbox. |
| mailboxSettings_userPurpose | String | The intended purpose of the user's mailbox. |
| mailboxSettings_workingHours_daysOfWeek | String | The days of the week specified as the user's working hours. |
| mailboxSettings_workingHours_endTime | Time | The end time for the user's working hours on a typical day. |
| mailboxSettings_workingHours_startTime | Time | The start time for the user's working hours on a typical day. |
| mailboxSettings_workingHours_timeZone_name | String | The name of the time zone for the user's working hours. |
| mailNickname | String | The email alias or nickname assigned to the user. |
| mobilePhone | String | The user's primary mobile phone number. |
| mySite | String | The URL to the user's personal site or workspace. |
| officeLocation | String | The physical office location associated with the user. |
| onPremisesDistinguishedName | String | The distinguished name (DN) of the user from the on-premises Active Directory. |
| onPremisesDomainName | String | The domain name synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute1 | String | A custom extension attribute synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute10 | String | Custom extension attribute 10 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute11 | String | Custom extension attribute 11 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute12 | String | Custom extension attribute 12 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute13 | String | Custom extension attribute 13 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute14 | String | Custom extension attribute 14 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute15 | String | Custom extension attribute 15 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute2 | String | Custom extension attribute 2 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute3 | String | Custom extension attribute 3 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute4 | String | Custom extension attribute 4 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute5 | String | Custom extension attribute 5 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute6 | String | Custom extension attribute 6 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute7 | String | Custom extension attribute 7 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute8 | String | Custom extension attribute 8 synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute9 | String | Custom extension attribute 9 synchronized from the on-premises directory. |
| onPremisesImmutableId | String | An identifier used to associate the on-premises directory user with their cloud account. |
| onPremisesLastSyncDateTime | Datetime | The last date and time the user account was synchronized with the on-premises directory. |
| onPremisesProvisioningErrors | String | A record of errors encountered during on-premises synchronization. |
| onPremisesSamAccountName | String | The SAM account name synchronized from the on-premises directory. |
| onPremisesSecurityIdentifier | String | The security identifier (SID) for the user synchronized from on-premises. |
| onPremisesSyncEnabled | Bool | Indicates whether the user account is currently being synchronized with an on-premises directory. |
| onPremisesUserPrincipalName | String | The userPrincipalName synchronized from the on-premises directory. |
| otherMails | String | A list of alternate email addresses associated with the user. |
| passwordPolicies | String | Defines the password policies applied to the user, such as expiration rules. |
| passwordProfile_forceChangePasswordNextSignIn | Bool | Indicates whether the user must change their password at the next sign-in. |
| passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | Indicates whether the user must change their password at the next sign-in with multi-factor authentication. |
| passwordProfile_password | String | The user's password details stored in the password profile. |
| pastProjects | String | A list of past projects the user has worked on. |
| postalCode | String | The postal code for the user's mailing address. |
| preferredDataLocation | String | The preferred geographic location for the user's data. |
| preferredLanguage | String | The user's preferred language for communication and system settings. |
| preferredName | String | The name the user prefers to be addressed by. |
| provisionedPlans | String | The plans that have been provisioned and activated for the user. |
| proxyAddresses | String | A list of email addresses and aliases associated with the user. |
| responsibilities | String | A list of tasks or duties assigned to the user. |
| schools | String | A list of schools or educational institutions attended by the user. |
| securityIdentifier | String | The unique security identifier (SID) assigned to the user. |
| serviceProvisioningErrors | String | Details of any service-specific errors encountered during provisioning. |
| showInAddressList | Bool | Specifies whether the user appears in the organization's address list. |
| signInActivity_lastNonInteractiveSignInDateTime | Datetime | The timestamp of the user's most recent non-interactive sign-in. |
| signInActivity_lastNonInteractiveSignInRequestId | String | The ID of the request for the last non-interactive sign-in. |
| signInActivity_lastSignInDateTime | Datetime | The timestamp of the user's most recent interactive sign-in. |
| signInActivity_lastSignInRequestId | String | The ID of the request for the last interactive sign-in. |
| signInSessionsValidFromDateTime | Datetime | Indicates that all tokens issued before this time are invalid. |
| skills | String | A list of skills or expertise provided by the user. |
| state | String | The state or province of the user's address. |
| streetAddress | String | The street address of the user's location. |
| surname | String | The user's last name or family name. |
| usageLocation | String | The two-letter country code indicating the user's location, often required for licensing. |
| userPrincipalName | String | The user's principal name used for sign-in (for example, email address). |
| userType | String | A classification of the user type, such as member or guest. |
| authentication_id | String | The unique identifier for the user's authentication details. |
| calendar_id | String | The identifier for the user's calendar. |
| cloudClipboard_id | String | The identifier for the user's cloud clipboard service. |
| drive_id | String | The identifier for the user's OneDrive storage. |
| employeeExperience_id | String | The identifier for the user's employee experience profile. |
| inferenceClassification_id | String | The identifier for the classification used for managing the relevance of the user's email messages. |
| insights_id | String | The identifier for the relationships between the user and other items. |
| manager_id | String | The identifier for the user's manager in the directory. |
| onenote_id | String | The identifier for the user's OneNote notebook. |
| outlook_id | String | The identifier for the user's Outlook profile. |
| photo_id | String | The identifier for the user's profile photo. |
| planner_id | String | The identifier for the user's Microsoft Planner. |
| presence_id | String | The identifier representing the user's presence status. |
| settings_id | String | The identifier for the user's settings profile. |
| teamwork_id | String | The identifier for the user's collaboration profile. |
| todo_id | String | The identifier for the user's Microsoft To-Do service. |