web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Connectors / Cannot Get Dynamic Dat...
Power Automate - Using Connectors
Unanswered

Cannot Get Dynamic Data from Smartsheet Spreadsheet

(2) ShareShare
ReportReport
Posted on by Tiger3423 4

I am trying to have new rows in a smart sheet update my local sql server. The actual colums are not showing up as dynamic data for us in the sql server fields. Please tell me how to get the columns from the smart sheet so I can use them to create a new row on the sql server.

Categories:
Connecting to Data
I have the same question (0)
  • v-monli-msft Profile Picture
    v-monli-msft on at
    Re: Cannot Get Dynamic Data from Smartsheet Spreadsheet

    Hi Tiger,

     

    I got the same result. All my columns in smartsheets are not showing in the Insert Row action. I will try to involve more resource to look into this issue.

     

    Regards,

    Mona

  • v-monli-msft Profile Picture
    v-monli-msft on at
    Re: Cannot Get Dynamic Data from Smartsheet Spreadsheet

    Hi Tiger,

     

    The product team has been noticed about this issue, they will look into it later. Thanks for your report and sorry for any inconvenience.

     

    Regards,

    Mona

  • joenilson Profile Picture
    joenilson 4 on at
    Re: Cannot Get Dynamic Data from Smartsheet Spreadsheet

    Any news to solve this problem?, i have the same issue,

     

    Regards

     

    JN

  • SeanHolm Profile Picture
    SeanHolm 6 on at
    Re: Cannot Get Dynamic Data from Smartsheet Spreadsheet

    Its 1year and almost 9months later - and getting data from smartsheet still does NOT work plus there has been NO feedback from the so called team working on this...

     

    If i've missed something, and someone has made it work, then please post an example of your flow that copies data from smartsheet to Excel or CSV.

  • pthakkar Profile Picture
    pthakkar 2 on at
    Re: Cannot Get Dynamic Data from Smartsheet Spreadsheet

    Same problem! Is anyone listening? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 614 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 401 Moderator

#3
chiaraalina Profile Picture

chiaraalina 282

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans