Copying data from Smartsheet to Excel with Power Automate
Hey all,
I'm trying to back up my smart sheet important data by copying it into an Excel sheet.
The issue is that I get array of rows that should be the column of the row that was copied from smart sheet.
See attached pictures. I don't understand why I cannot get a variable
for each column in specific row
Data On smart sheet:
the integration options on Power automate
The data I get as a JSON
The data entered into excel
Answers
-
I found two posts that may be related to this in the Power Automate Community. They both resolved the issue by using the expression builder:
If neither of these posts have helped, I would recommend posting in the Power Automate Community to see if other users have alternate solutions.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives