Unanswered

Get Planner Task description and add to a collection

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

BCLS776 8,994 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
jjamisn 24 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report
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.

Was this reply helpful? Yes No
jjamisn 24 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

BCLS776 8,994 Moderator on at

Like (1)

Report
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.

Was this reply helpful? Yes No