How to retrieve the data from Planner.GetPlanDetails

(0) Share

Report

Posted on by LennartWalldén

173

Hi all,

I have made a calendar listing Planner tasks, and I would also like to give the users possibility to create new tasks. When creating new tasks, I want to get all categories from a plan that is chosen by a user. I then want to display the answer in a dropdown the user could chose categories from, when creating the new task.

I have tried this solution, but it don't work.
In OnChange from the Plan dropdown:

// Create collection of the chosen plans categories
ClearCollect(
    colPlanCategories;
        Planner.GetPlanDetails(
        LookUp(
            colPlannerBucketlist;
            PlanName = drpAddItemPlan.Selected.Value
        ).PlanID
    ).categoryDescriptions
)

 
And then I put the colPlanCategories as Items in the Categories dropdown.



But the data in colPlanCategories has no column names, so I can't wrap my head around how I should produce the category list.

The data in colPlanCategories, is just one record which looks like this when i look at them in PowerApps Studio.

 
All ideas on how to split this up to a table with two columns, category and categoryName is appreciated.
 

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

SaiRT14 1,990 Super User 2025 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The issue you're encountering is because the categoryDescriptions property from the Planner API likely returns data in a nested JSON structure, and Power Apps does not automatically convert this into a usable table with distinct columns.

{
"category1": "Marketing",
"category2": "Development",
"category3": "Testing"
}

Use the ForAll function combined with Ungroup or Collect to transform the object into a table format.

Was this reply helpful? Yes No
ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

You would first need to parse the JSON to a collection. Look at this documentation to get an understanding of how this is performed ParseJSON function - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
LennartWalldén 173 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the answers but I can't get any of them to work, can anyone give me a code example?

Was this reply helpful? Yes No