Column Names in Power Flow (Copy data from Smartsheet to Excel)

Rashad Pashazade
Rashad Pashazade ✭✭
edited 06/14/22 in Add Ons and Integrations

hi,

i am trying to build this MS Power Flow to copy new data entries from Smarsheet to Excel and create new rows in Excel.

but i cannot get it working, as i dont know what to put in these empty bars below column names (yellow highlights):

I assumed it would be just exact column names in smartsheet, but it isnt, as when i add corresponding smartsheet column names into these boxes the flow breaks and doesnt run.

BTW, in first Smartsheet step, i have put the smartsheet name that holds a number of data files - all with the same column names.

image.png


can someone please help?

thanks so much!

· Share on FacebookShare on Twitter

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Rashad Pashazade

    This may be a better question to ask in the Power Automate Community (here), since it has to do with how the Power Automate workflow is configured.

    I did a quick search and it looks like there was a similar question posted there (see this link) where the answer says to create an individual flow per-Smartsheet sheet, versus selecting a folder. I would suggest trying this, first, to see if selecting an individual sheet as the source resolves your issue.

    Cheers!

    Genevieve

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

    · Share on FacebookShare on Twitter

Answers

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video