Answered

Get Planner Task description and add to a collection

Like (0) Share

Report

Posted on 23 Jul 2021 13:31:46 by jjamisn

I am trying to create a gallery of planner tasks that can be searched using specific sections of the text within the task description because the task is created using a power automate and is always in the same format.

I believe I need to add a column to my collection of tasks to grab the description, but I can not make it work.

Here is what I was trying: ClearCollect(cDesignImprovements, AddColumns(Filter(Planner.ListTasksV3("Plan ID","Group ID").value,bucketId="Bucket"),"TaskDescript",Planner.GetTaskDetailsV2(id)))

Any help would be appreciated!

Categories:

Using Apps Using Formulas

General Questions

All responses (5)

Answers (1)

Verified answer

BCLS776 8,988 Super User 2025 Season 1 on 23 Jul 2021 at 17:04:13

Like (1)

Report
Re: Get Planner Task description and add to a collection

Gotcha, how about a slightly different approach?:
ForAll(Planner.ListTasksV3("PlanID", "TaskID").value, Collect(cDesignImprovements, { TaskName: ThisRecord.title, TaskNotes: Planner.GetTaskDetailsV2(ThisRecord.id).description // Add other fields you want to collect here } ) )
You can populate the collection with additional terms in the Collect() function with the data you need for your app.
jjamisn 24 on 23 Jul 2021 at 16:10:06

Like (0)

Report

Re: Get Planner Task description and add to a collection

I may be using the wrong terminology in what I am asking for. That did give me the title of the task. but I am really looking for the Notes portion on the actual Planner task. (in the yellow box in the picture)

I know within powerapps I can use the Planner.GetTaskDetailsV2(taskID).description and return this on my gallery. But I need that notes section in my collection so I can get some of the text out of it and search using what I take out.
BCLS776 8,988 Super User 2025 Season 1 on 23 Jul 2021 at 15:51:31

Like (0)

Report
Re: Get Planner Task description and add to a collection

I can see names of individual tasks at this level of query:

Planner.ListTasksV3(PlanID, GroupID).value.title

Try this code:
ClearCollect(cDesignImprovements, AddColumns( Planner.ListTasksV3("PlanID", "TaskID").value, "TaskDescript", title ) )
Make sure that code is collecting the task description you want, and then add back your Filter.
jjamisn 24 on 23 Jul 2021 at 15:00:37

Like (0)

Report

Re: Get Planner Task description and add to a collection

I had hardcoded the group and plan id into the function. I removed them from my initial post to look more general. The part I really need help with is adding the task description to my cDesignImprovements collection.
BCLS776 8,988 Super User 2025 Season 1 on 23 Jul 2021 at 14:38:17

Like (0)

Report

Re: Get Planner Task description and add to a collection

To use the connector properly, you'll need to specify the actual ID for Plan ID and Group ID that you want to query.

Try the the Planner.ListMyPlansV2().value query to start, which gives you back a table of plan titles and IDs. From there you can filter and access the specific tasks in a plan using the plan's ID.

To get Group ID, query using the Office365Groups.ListOwnedGroups_V3 connector. You can make some functionality to choose the group, or hardcode in the ID if that's easier for you.

Once you have those IDs, you can plug them into your ClearCollect and get further to your results.