Import data into a datatable from power automate
Options
jpcook
✭
I am using power automate to get data from my SQL server database. I want to then push that data to a smartsheet datatable.
I currently am able to push the data to a smartsheet using insert row in power automate.
another option would be to push the data directly from SQL database to a datatable.
I am new to smartsheets so any help with this would be greatly appreciated
Thanks
Tags:
Answers
-
Hey @jpcook did you get this figured out? You can use Python to transfer directly from the SQL to Smartsheet. I find the data transfer tricky so I almost always create a landing sheet for the data, then use Data Mesh to transfer the information wherever I need.