Users
Represents various ways a user can view assigned tasks.
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.
- Id supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Users WHERE UserId = '9523f1-aa0-4fe17-a9w7b-6860618adf'
Columns
| Name | Type | Description |
| UserId [KEY] | String | The ID of the user. |
| aboutMe | String | The label About Me corresponds to this field. |
| accountEnabled | Bool | The label account enabled corresponds to this field. |
| ageGroup | String | Typically used to set the age group of the user. |
| assignedLicenses | String | The licenses that are assigned to the user, including inherited licenses. |
| assignedPlans | String | The plans that are assigned to the user. |
| authorizationInfo_certificateUserIds | String | Label Authorization Info Certification User IDs corresponds to this field. |
| birthday | Datetime | The birthday of the user. |
| businessPhones | String | The telephone numbers for the user. |
| city | String | The city where the user is located. |
| companyName | String | The name of the company that the user is associated with. |
| consentProvidedForMinor | String | Typically used to set whether consent was obtained for minors. |
| country | String | The country/region where the user is located. |
| createdDateTime | Datetime | The date and time the user was created. |
| creationType | String | Specifies the method by which the user account was created. |
| customSecurityAttributes | String | An open complex type that holds the value of a custom security attribute that is assigned to a directory object. |
| department | String | The name of the department in which the user works. |
| deviceEnrollmentLimit | Int | Label Device Enrollment Limit corresponds to this field. |
| displayName | String | The name displayed in the address book for the user. |
| employeeHireDate | Datetime | The date and time when the user was hired or will start work in a future hire. |
| employeeId | String | The employee identifier assigned to the user by the organization. |
| employeeLeaveDateTime | Datetime | The date and time when the user left or will leave the organization. |
| employeeOrgData_costCenter | String | Represents cost center organization data associated with the employee. |
| employeeOrgData_division | String | Represents division organization data associated with the employee. |
| employeeType | String | Captures enterprise worker type. |
| externalUserState | String | This property represents the invited user's invitation status. |
| externalUserStateChangeDateTime | Datetime | Shows the timestamp for the latest change to the externalUserState property. |
| faxNumber | String | The fax number of the user. |
| givenName | String | The first name of the user. |
| hireDate | Datetime | The hire date of the user. |
| identities | String | Specifies the identities that can be used to sign in to this user account. |
| imAddresses | String | The instant message voice-over IP session initiation protocol addresses for the user. |
| interests | String | A list for the user to describe their interests. |
| isResourceAccount | Bool | Do not use. This is reserved for future use. |
| jobTitle | String | The user's job title. |
| lastPasswordChangeDateTime | Datetime | The last time the user changed their password or when their password was created, whichever date is the most recent. |
| legalAgeGroupClassification | String | Typically used by enterprise applications to determine the legal age group of the user. |
| licenseAssignmentStates | String | State of license assignments for this user. |
| String | The Simple Mail Transfer Protocol address for the user. | |
| mailboxSettings_archiveFolder | String | Label Mailbox Settings Archive Folder corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_externalAudience | String | Label Mailbox Settings Automatic Replies External Audience corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_externalReplyMessage | String | Label Mailbox Settings Automatic Replies External Reply Message corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_internalReplyMessage | String | Label Mailbox Settings Automatic Replies Internal Reply Message corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_dateTime | String | Label Mailbox Settings Automatic Replies Scheduled End Date Time corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_timeZone | String | Label Mailbox Settings Automatic Replies Scheduled End Date Timezone corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_status | String | Label Mailbox Settings Automatic Replies Status corresponds to this field. |
| mailboxSettings_dateFormat | String | Label Mailbox Settings Automatic Replies Date Format corresponds to this field. |
| mailboxSettings_delegateMeetingMessageDeliveryOptions | String | Label Mailbox Settings Delegate Meeting Message Delivery Options corresponds to this field. |
| mailboxSettings_language_displayName | String | Label Mailbox Settings Language Display Name corresponds to this field. |
| mailboxSettings_language_locale | String | Label Mailbox Settings Language Locale corresponds to this field. |
| mailboxSettings_timeFormat | String | Label Mailbox Settings Time Format corresponds to this field. |
| mailboxSettings_timeZone | String | Label Mailbox Settings Time Zone corresponds to this field. |
| mailboxSettings_userPurpose | String | Label Mailbox Settings User Purpose corresponds to this field. |
| mailboxSettings_workingHours_daysOfWeek | String | Label Mailbox Settings Working Hours Days of Week corresponds to this field. |
| mailboxSettings_workingHours_endTime | Time | Label Mailbox Settings Working Hours End Time corresponds to this field. |
| mailboxSettings_workingHours_startTime | Time | Label Mailbox Settings Working Hours Start Time corresponds to this field. |
| mailboxSettings_workingHours_timeZone_name | String | Label Mailbox Settings Working Hours Time Zone Name corresponds to this field. |
| mailNickname | String | The mail alias for the user. |
| mobilePhone | String | The primary cellular telephone number for the user. |
| mySite | String | The URL for the user's site. |
| officeLocation | String | The office location in the user's place of business. |
| onPremisesDistinguishedName | String | Contains the on-premises Active Directory distinguished name or DN. |
| onPremisesDomainName | String | Contains the on-premises domainFQDN, also called dnsDomainName synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute1 | String | Contains Extension Attributes 1. |
| onPremisesExtensionAttributes_extensionAttribute10 | String | Contains Extension Attributes 10. |
| onPremisesExtensionAttributes_extensionAttribute11 | String | Contains Extension Attributes 11. |
| onPremisesExtensionAttributes_extensionAttribute12 | String | Contains Extension Attributes 12. |
| onPremisesExtensionAttributes_extensionAttribute13 | String | Contains Extension Attributes 13. |
| onPremisesExtensionAttributes_extensionAttribute14 | String | Contains Extension Attributes 14. |
| onPremisesExtensionAttributes_extensionAttribute15 | String | Contains Extension Attributes 15. |
| onPremisesExtensionAttributes_extensionAttribute2 | String | Contains Extension Attributes 2. |
| onPremisesExtensionAttributes_extensionAttribute3 | String | Contains Extension Attributes 3. |
| onPremisesExtensionAttributes_extensionAttribute4 | String | Contains Extension Attributes 4. |
| onPremisesExtensionAttributes_extensionAttribute5 | String | Contains Extension Attributes 5. |
| onPremisesExtensionAttributes_extensionAttribute6 | String | Contains Extension Attributes 6. |
| onPremisesExtensionAttributes_extensionAttribute7 | String | Contains Extension Attributes 7. |
| onPremisesExtensionAttributes_extensionAttribute8 | String | Contains Extension Attributes 8. |
| onPremisesExtensionAttributes_extensionAttribute9 | String | Contains Extension Attributes 9. |
| onPremisesImmutableId | String | This property is used to associate an on-premises Active Directory user account. |
| onPremisesLastSyncDateTime | Datetime | Indicates the last time at which the object was synced with the on-premises directory. |
| onPremisesProvisioningErrors | String | Errors when using Microsoft synchronization product during provisioning. |
| onPremisesSamAccountName | String | Contains the on-premises SAM Account Name synchronized from the on-premises directory. |
| onPremisesSecurityIdentifier | String | Contains the on-premises security identifier for the user that was synchronized from on-premises to the cloud. |
| onPremisesSyncEnabled | Bool | This field is true if this user object is currently being synced from an on-premises Active Directory. |
| onPremisesUserPrincipalName | String | Contains the on-premises userPrincipalName synchronized from the on-premises directory. |
| otherMails | String | A list of other email addresses for the user. |
| passwordPolicies | String | Specifies password policies for the user. |
| passwordProfile_forceChangePasswordNextSignIn | Bool | Specifies that the user will be forced to change the password on the next sign-in. |
| passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | Specifies that the user will be forced to change the password on the next sign-in with multi-factor authentication. |
| passwordProfile_password | String | Specifies the password profile for the user. |
| pastProjects | String | A list for the user to enumerate their past projects. |
| postalCode | String | The postal code for the user's postal address. |
| preferredDataLocation | String | The preferred data location for the user. |
| preferredLanguage | String | The preferred language for the user. |
| preferredName | String | The preferred name for the user. |
| provisionedPlans | String | The plans that are provisioned for the user. |
| proxyAddresses | String | Label Proxy Addresses corresponds to this field. |
| responsibilities | String | A list for the user to enumerate their responsibilities. |
| schools | String | A list for the user to enumerate the schools they attended. |
| securityIdentifier | String | Security identifier of the user. |
| serviceProvisioningErrors | String | Errors published by a federated service describing a nontransient, service-specific error regarding the properties or link from a user object. |
| showInAddressList | Bool | Label Show In Address List corresponds to this field. |
| signInActivity_lastNonInteractiveSignInDateTime | Datetime | Specifies the last non-interactive signed-in date and time of the sign-in for a given user. |
| signInActivity_lastNonInteractiveSignInRequestId | String | Specifies the last non-interactive signed-in request ID of the sign-in for a given user. |
| signInActivity_lastSignInDateTime | Datetime | Specifies the last signed-in date and time of the sign-in for a given user. |
| signInActivity_lastSignInRequestId | String | Specifies the last signed-in request ID of the sign-in for a given user. |
| signInSessionsValidFromDateTime | Datetime | Specifies any refresh tokens or session tokens issued before this time are invalid. |
| skills | String | A list for the user to enumerate their skills. |
| state | String | The state or province in the user's address. |
| streetAddress | String | The street address of the user's place of business. |
| surname | String | The user's last name. |
| usageLocation | String | A two-letter country code required for users that are assigned licenses due to legal requirements to check for availability of services in countries. |
| userPrincipalName | String | The user principal name of the user. |
| userType | String | A string value that can be used to classify user types in your directory. |
| authentication_id | String | The authentication ID of the user. |
| calendar_id | String | The calendar ID of the user. |
| cloudClipboard_id | String | The user's cloud clipboard ID. |
| drive_id | String | The user's OneDrive ID. |
| employeeExperience_id | String | The Employee Experiene ID of the user. |
| inferenceClassification_id | String | Specifies the classification of the user's messages based on explicit designations that override inferred relevance or importance. |
| insights_id | String | Specifies the relationships between a user and items. |
| manager_id | String | The ID of the user's manager. |
| onenote_id | String | The OneNote ID of the user. |
| outlook_id | String | The Outlook ID of the user. |
| photo_id | String | The user's profile photo ID. |
| planner_id | String | The user's planner ID. |
| presence_id | String | Label Presence ID corresponds to this field. |
| settings_id | String | Label Settings ID corresponds to this field. |
| teamwork_id | String | Label Teamwork ID corresponds to this field. |
| todo_id | String | Specifies the To Do services available to a user. |