TaskComments
Captures discussions, notes, and comments related to tasks within a plan, fostering collaboration and communication.
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.
If Scope = NoAdminConsent: Lists data related to the groups that the user is a member of.
If Scope = AdminConsent: Lists all data related to groups.
- GroupId supports the '=' operator.
- ConversationThreadId supports the '=' operator.
For example, the following queries are processed server-side:
SELECT * FROM TaskComments SELECT * FROM TaskComments WHERE GroupId = '73094928-3786-4246-a0d1-90c' SELECT * FROM TaskComments WHERE ConversationThreadId = 'AAQkADBlMTk2ZmZjLTJlZmYtNGQ0Zi05ZmViLTQwNzM0MWM0NWU5ZAMkABAAWZ7-9ddvEUa7ZFI' SELECT * FROM TaskComments WHERE ConversationThreadId = 'AAQkADBlMTk2ZmZjLTJlZmYtNGQ0Zi05ZmViLTQwNzM0MWM0NWU5ZAMkABAAWZ7-9ddvEUa7ZFI' and GroupId = '73094928-3786-4246-a0d1-90c'
If no filter is provided, the add-in queries Tasks and reads the comments for each task.
Columns
| Name | Type | Description |
| conversationId [KEY] | String | The unique identifier for the conversation associated with the task comment. |
| body_content | String | The main content or message body of the task comment. |
| body_contentType | String | The format type of the content in the message body (for example, plain text, HTML). |
| conversationThreadId | String | The unique identifier for the thread within the conversation. |
| from_emailAddress_address | String | The email address of the individual or entity that sent the message. |
| from_emailAddress_name | String | The display name of the individual or entity that sent the message. |
| hasAttachments | Bool | Indicates whether the task comment includes any attachments. |
| newParticipants | String | A list of new participants added to the conversation. |
| receivedDateTime | Datetime | The timestamp when the message was received, including date and time. |
| sender_emailAddress_address | String | The email address of the sender of the task comment. |
| sender_emailAddress_name | String | The display name of the sender of the task comment. |
| inReplyTo_id | String | The unique identifier of the message to which this comment is replying. |
| GroupId | String | The unique identifier of the group associated with the task comment. |