Add a row from Smartsheet to excel

[Anonymous]

Hello, 

I am workign on a flow that copies rows into an excel spreadsheet. But I can't seem to get any of the dynamic content into the excel sheet i want to transfer the information? Is  this maybe not the flow i use for that?

Thank you in advance! 

Gina 

[faustocapellanj · Accepted solution]

HI @Anonymous 

If I remember well, I was working with a client a while back that wanted to do something similar to this, and he ended up backing out because the Smartsheets connector wasn't giving him the info that he needed because it was all embedded in some HTML. This might be inside the Data Sheet HTML displayed in your Dynamic content.

Another you can try, add an action after your trigger like Get the columns of a sheet and pass the Sheet Id from the sheet in the trigger. That may give you more content you can use to add to your Excel file. Here's the documentation for the Smartsheet connector: https://docs.microsoft.com/en-us/connectors/smartsheet/ 

Please give that a shot and let us know.

Regards,

[Anonymous]

Thank you this definitely helped!