cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michalsiwik
Level: Powered On

Export planner tasks list to excel (get all information like destriptions, comments etc.)

So I have problem with exporting "My tasks list" from single planner, or all planners to excel. My question are: 1. How to parse this diffrent ID's to usernames, planner names, titles, and descriptions. Only dates, are in quite readable format 2. Why even in in my planner are maybe about 20 taks (completed + uncompleted), flow do apply for each 117 times, and do copied insert rows? My flow https://imgur.com/gUGLbXd My desired output https://imgur.com/m76cKie Output i get with my flow https://imgur.com/ed7HCCB

 

------------After edit below----------------------

 

Hi @

 

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Export planner tasks list to excel (get all information like destriptions, comments etc.)

Hi @michalsiwik ,

 

If your "apply for each" have run 117 times, that means you have 117 tasks in your planner, please check from the flow run history to see the tasks in the 117 loops.

 

Could you please share a screenshot of the excel table that you would insert rows and please share the corresponding flow with columns in the excel, also please share the rin history so we would better understand your issue and provide a proper workaround for you.

 

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

michalsiwik
Level: Powered On

Re: Export planner tasks list to excel (get all information like destriptions, comments etc.)

Hey @v-yuazh-msft  i edited my previously message.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,689)