Column Names in Power Flow (Copy data from Smartsheet to Excel)
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!
Best Answer
-
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
Answers
-
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
-
thanks heaps! :)