Users
Tracks user-specific task views and preferences, enabling personalized task management experiences.
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.
- 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. |