TaskComments
Captures discussions, notes, and comments related to tasks within a plan, fostering collaboration and communication.
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.
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'
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. |