Plans
Displays task plan data from Microsoft Planner, including plan names, owners, and associated group IDs.
Table Specific Information
Using Plans requires access to Groups permissions. This requires Admin approval. For this reason, you must use your own OAuth App to add the Groups permissions and from the Microsoft Graph. See Creating an Entra ID (Azure AD) Application for more details.
Select
All plans in MS Planner exist as a part of a group. In order to retrieve the list of available plans, you must retrieve a list of available plans per group.
If no GroupId is specified, then the following WHERE condition will be appended to any query:
GroupId IN (SELECT Id FROM Groups)
Columns
| Name | Type | References | Description |
| container_containerId | String | Identifier of the container that holds the plan, typically referencing a Microsoft 365 Group or Team. | |
| container_type | String | Type of container where the plan is stored, such as group or roster. | |
| container_url | String | URL link to the container that holds the plan, such as the associated Group or Team. | |
| createdBy_application_displayName | String | Display name of the application that created the plan. | |
| createdBy_application_id | String | Unique identifier of the application that created the plan. | |
| createdDateTime | Datetime | Timestamp indicating when the plan was created. | |
| owner | String | Identifier of the user or entity that owns the plan. | |
| title | String | Title or name of the plan as displayed in Microsoft Planner. | |
| GroupId | String | Identifier of the Microsoft 365 Group associated with the plan. | |
| Id [KEY] | String | Unique identifier of the plan. |