Integrate Smartsheet with Flows on update of a row in smartsheet
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
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
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 for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
