Copying data from Smartsheet to Excel with Power Automate

Shahar Gur-Ari

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

Genevieve P.

Hi @Shahar Gur-Ari

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:

• Post 1: Smartsheet - When new row is added
• Post 2:  Dynamic content not working with Smartsheet

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