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!

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Rashad Pashazade

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

All comments

Genevieve P.

Hi @Rashad Pashazade

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.

Cheers!

Genevieve

Rashad Pashazade

https://community.smartsheet.com/discussion/comment/274556#Comment_274556

thanks heaps! :)

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.