Integrate Smartsheet with Flows on update of a row in smartsheet

debajit

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

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

Genevieve P.

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. 

agbush

Hello - I have same "Update" row issue -looking to use Microsoft Flow to add and update rows in Smartsheet for individual epics and features to provide rollup reporting on one place