Exporting task details

[gmorgan28]

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.

[faustocapellanj · Accepted solution]

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

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

Regards,

[gmorgan28]

Awesome. This was just what I needed thanks!