I'm looking for help in the best way to connect a PMO Portfolio of Projects in Smartsheets to Microsoft Planner. I want to be able to enable all 'Assigned' rows in each and every project plan to automate into 1 Microsoft Planner carrying over the Project Name, Task Description and Due date. I also want to do the reverse. When a task is marked completed in Planner, I want it to update in Smartsheet.
I've connected Smartsheets with Microsoft Planner using Power Automate but the latest instructions I've found in the community recommendations online aren't detailed enough on how in Smartsheets you can best roll-up the tasks and but then also automate the update back from Microsoft Planner when marked complete.
Anyone have instructions or a resource that can help?
VictorIvanidze
4
BK-01100935-0
4
frontrowna
2