Integrate Smartsheet with Flows on update of a row in smartsheet

10/03/19 Edited 12/09/19

Hi Team,

We are using Smartsheet and Dynamics 365 and one of our requirement is to integrate smartsheet with Dynamics 365.

We are primarily using flows for connectivity across applications and we are trying to leverage the smartsheet connector available in flows. Basically we are currently in need to update back something in Dynamics once a smartsheet row is created or updated.

The create scenario works fine since there is a trigger "When a new row is created". However there is nothing as such for update. "When a sheet is updated" trigger is there but that does not return which row has been updated and which fields for that matter. It just returns us the list of all the records currently there in the sheet.

We are really in need of help here. 

Any suggestion greatly appreciated.

 

Cheers!

Debajit

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Debajit,

    Have you looked at using the Smartsheet for Microsoft Dynamics 365 Connector?

    More info: https://www.smartsheet.com/marketplace/apps/smartsheet-microsoft-dynamics-365-connector

    Hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hello Debajit,

    It appears that the issues resides within the Flow application. Flow has only published a certain amount of Smartsheet configurations that can be used in conjunction with our application. This may be something they intend to release in a future update, but as of now, we do not have any input on what is created and released.

    As mentioned by Andre, the Microsoft Dynamics 365 Connector may be an alternative solution that can be used. Please also feel free to raise an Enhancement Request to our Product Team. 

Sign In or Register to comment.