Import Tasks From MS Planner to Excel Automatically

[legalhustler]

Hello All,

Is there a way for me to import tasks from Microsoft Planner, including bucket names and details (i.e. start dates, due dates, notes, etc) into Excel? Anytime there something changes in the Planner I want it reflected in Excel. Will Power Query work or do I need to use Power Automate? Any videos/links on how to do it would be helpful.

Thanks!

 

[Matt Allington]

I did some work using Power Automate and Planner. Pretty sure this was the video

this goes the other way, but i was then able to work out how to pull the tasks back to Excel from there