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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
thanks heaps! :)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives