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

Rashad Pashazade · 01/07/21

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.

can someone please help?

thanks so much!

Genevieve P. · 01/11/21

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

Genevieve P. · 01/11/21

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

Rashad Pashazade · 01/12/21

https://community.smartsheet.com/discussion/comment/274556#Comment_274556

thanks heaps! :)

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

Best Answer

Answers

Categories