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!

Awesome. This was just what I needed thanks!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,071)