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:

2021-08-10 13_43_30-Stencil order follow-up - Smartsheet.com and 2 more pages - Work - Microsoft Ed.png

the integration options on Power automate

2021-08-10 13_47_27-Edit your flow _ Power Automate.png

The data I get as a JSON

The data entered into excel

2021-08-10 13_44_13-מעקב הזמנת מסכות.xlsx - Excel.png

Find more posts tagged with

Automations

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.