cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gmorgan28
Frequent Visitor

Exporting task details

I'm trying to create a CSV export file from my Planner that has the name of the task, whether it has the cranberry label, and the names of checklist item IDs 1 and 2. I'm able to export out the task name and whether it has the label or not but haven't been able to get the checklist items. My current working flow with just task title and label status looks like this. Not sure how to get check list items into it.

gmorgan28_0-1625070241714.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
faustocapellanj
Memorable Member
Memorable Member

Hello @gmorgan28 

The approach outlined below is the one I used to export the Planner Tasks with their Checklist items.

  1. I use the same trigger you have, so nothing different here.
  2. For the next action, I added an Initialize variable action. Set the Name property to the name of the variable, and the Type to Array.
    planner-1.PNG

  3. For the next action, I added a Planner - List tasks, same as the action shown in your screenshot.
  4. For the next action, I added a Filter array, same as the action shown in your screenshot and the same filter.
    planner-2.PNG

  5. For the next action, I added an Apply to each and renamed it to ForEach Task. This action will loop through each task and execute several actions within it. For this one, I set the Select an output from previous steps to the Body of the Filter array action above. Then inside this loop I added the following actions:
    1. The first action added to the loop is a Planner - Get task details. As the name implies, it is being used to get all the details of each task.
    2. The next action added to the loop is an Apply to each and renamed it to ForEach CheckListItem. This action is being used because the Checklist property is an array and the flow needs to loop through each item.
    3. Then, inside this loop, I added an Append to array variable action so it can capture all the columns that will be used in the CSV export. The first 5 properties in the screenshot below come from the output of the Filter array action, and the remaining ones come from the Checklist property in the loop.
      Note: the lastModifiedByuserdisplayName property is set by using an expression. For some reason, this property is not available in the Dynamic Content window.
      planner-3.PNG

  6. After all the looping is completed, the next action I added is a Create CSV table. I set the From field to the array in step 2 above and I left the Columns value to Automatic.
    planner-4.PNG

  7. For the last action, I added a SharePoint - Create file to store the CSV file being created with all the information from the Planner Tasks.
    planner-5.PNG

 

Please try this approach and see if it works for you. Also, please reach out if you have any questions.

 

Regards,

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

View solution in original post

2 REPLIES 2
faustocapellanj
Memorable Member
Memorable Member

Hello @gmorgan28 

The approach outlined below is the one I used to export the Planner Tasks with their Checklist items.

  1. I use the same trigger you have, so nothing different here.
  2. For the next action, I added an Initialize variable action. Set the Name property to the name of the variable, and the Type to Array.
    planner-1.PNG

  3. For the next action, I added a Planner - List tasks, same as the action shown in your screenshot.
  4. For the next action, I added a Filter array, same as the action shown in your screenshot and the same filter.
    planner-2.PNG

  5. For the next action, I added an Apply to each and renamed it to ForEach Task. This action will loop through each task and execute several actions within it. For this one, I set the Select an output from previous steps to the Body of the Filter array action above. Then inside this loop I added the following actions:
    1. The first action added to the loop is a Planner - Get task details. As the name implies, it is being used to get all the details of each task.
    2. The next action added to the loop is an Apply to each and renamed it to ForEach CheckListItem. This action is being used because the Checklist property is an array and the flow needs to loop through each item.
    3. Then, inside this loop, I added an Append to array variable action so it can capture all the columns that will be used in the CSV export. The first 5 properties in the screenshot below come from the output of the Filter array action, and the remaining ones come from the Checklist property in the loop.
      Note: the lastModifiedByuserdisplayName property is set by using an expression. For some reason, this property is not available in the Dynamic Content window.
      planner-3.PNG

  6. After all the looping is completed, the next action I added is a Create CSV table. I set the From field to the array in step 2 above and I left the Columns value to Automatic.
    planner-4.PNG

  7. For the last action, I added a SharePoint - Create file to store the CSV file being created with all the information from the Planner Tasks.
    planner-5.PNG

 

Please try this approach and see if it works for you. Also, please reach out if you have any questions.

 

Regards,

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

View solution in original post

Awesome. This was just what I needed thanks!

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,748)