Import data into a datatable from power automate

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

Find more posts tagged with

DataTable

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.