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!
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.
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.
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.
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.
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.
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional