Import data into a datatable from power automate

edited 03/25/24 in API & Developers

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




  • Lucas Rayala
    Lucas Rayala ✭✭✭✭✭✭

    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.