Using Power Automate to transfer tasks from Smartsheet to Microsoft Planner

Andi Rapien

I am trying to set up a power automate between Smartsheet and Microsoft Planner. I want to create a new task every time a new line is added to the Smartsheet and be able to pull the person who it is assigned to, the start date, end date and the task name. Can anyone help? 

Ben Goldblatt

Hi @Andi Rapien,

I'm not sure about the specific setup involved for integrating Smartsheet and Microsoft Planner, but I found this information on using Microsoft Flow that may help to at least show what's possible with a Smartsheet/Microsoft integration: https://flow.microsoft.com/en-us/connectors/shared_smartsheet/smartsheet/

I also recommend submitting a Product Enhancement Request for a direct integration between Smartsheet and Microsoft planner to have this considered as a possibility for future development.

Thanks,

Ben

Ben Goldblatt

Andi,

You may also want to post your question in the Power Automate Community if you haven't done so already.

Thanks,

Ben

Will Squires

Hi @Ben Goldblatt - I've looked on https://powerautomate.microsoft.com/en-US/connectors/details/shared_smartsheet/smartsheet/ and no Microsoft Planner connectivity. I also need to be able to take information from Smartsheet and put it into Planner. Are you guys launching this ability any time soon? 🤞

FWPBIDev

Why so Smartsheet personnel point us to outside resources--more often than not--to answer Smartsheet-specific questions? Just provide an answer and, yes, thank you for the invitation to add a product enhancement request. I think we're all familiar with this by now.

MichelleW.

Bumping this up as it has been a couple of years and I am trying to do this exact thing. Any chance anyone has a clear solution on how to do this?