Hi Community,
I am working on a project to extract task details from a Planner board for a specific Plan ID and create a Power BI report. However, I am facing a few issues and would appreciate any guidance or suggestions.
Linking Applied Categories to Category Descriptions
Completed By User ID
Recurring Tasks
Thank you for the feedback!
I’ve attached two pictures to provide more context:
Get Plan Details and Append to Array:
Get Task Details and Compose Applied Category:
I am trying to compare the applied categories from the task details with the category descriptions from the plan details to retrieve the corresponding category description.
In the "Apply to each" loop for the tasks, I have a Compose action where I am attempting to extract the category description using the following expression:
first( filter( variables('CategoryDescriptions'), equals(item()?['planId'], items('Apply_to_each')?['planId']) ) )['categoryDescriptions'][items('Apply_to_each')?['key']]
Hi @TejaJuloori
Great write up. If you have any flow pictures it can help
Ok let me try to answer you where I can.
Linking Applied Categories to Category Descriptions
Completed By User ID
Recurring Tasks
Those answers explain how and what you asked.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Michael E. Gernaey
8
Super User 2025 Season 1
lbendlin
7
Super User 2025 Season 1
KT-07051015-0
4