cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate III
Advocate III

Smartsheet - When new row is added

I was trying to do something that I thought would be simple using MS Flow.  All I want to do is take some cell values from one sheet and add a new row to a different sheet and populate specific cells with the collected cells.  The problem is that there does not seem to be a way to tell the cell value once collected. As seen by the picture below I can get the row that was added with the specific cells named and on the step to add a new row it know the existing columns of the other sheet but how to I specify the collected data from step one?

 

 

 

Thank for any help.

 

Mike

Thanks,
Mike L.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Smartsheet - When new row is added

Hello All,

 

I figured out a work around for this and it is to use the expression builder.

 

here is the different expressions that I use:

 

first(triggerBody()?['cells'])?['value'] (first value from the array)
first(skip(triggerBody()?['cells'],1))?['value'] (Second value from the array)
first(skip(triggerBody()?['cells'],2))?['value'] (Third value from the array)

 

And you can just keep building this out as needed depending on how big your array is.

 

 

View solution in original post

13 REPLIES 13
Highlighted
Community Support
Community Support

Re: Smartsheet - When new row is added

Hi Mike,

 

Just tested with the same flow and I got the same result. In the "Insert Row" action, I cannot see all the columns from the trigger sheet too.

Capture.PNG

 

I have reported this to the product team and will get back once got any update.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate III
Advocate III

Re: Smartsheet - When new row is added

Mona,

 

It has been about a week now, is there any update on this?  I understand that it may take time so even if there is just a timeline to a fix that would be great.

 

Thanks

Thanks,
Mike L.
Highlighted
Community Support
Community Support

Re: Smartsheet - When new row is added

Hi Mike,

 

I have confirmed with product team that this is a known limitation in the connector today that we’re working to resolve. We don’t have an ETA but we are hoping to have a fix available soon.

 

Regard,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate I
Advocate I

Re: Smartsheet - When new row is added

While development is on this, I'll add that in general the SmartSheet connector leaves a lot to be desired:

1. Having to list the columns is a drag. Why not grab the names automatically?

2. Where is the row updated trigger? That seems like a really important one

Highlighted
Community Support
Community Support

Re: Smartsheet - When new row is added

Hi,

 

All these requirement can be posted to Idea forum here:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Regards,

Mona Li

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate I
Advocate I

Re: Smartsheet - When new row is added

Any update on this, or further information/documentation on the smartsheet connector? This is really, really underdeveloped as compared to your competitors - it should be grabbing all of the column names automatically for dynamic use in future steps - without that it's basically a useless connector. I tried some of the actions to get data values out of the sheet and for the life of me could not figure it out.

 

Thanks!

Highlighted
New Member

Re: Smartsheet - When new row is added

Any updates with the Smartsheet template? The column fields from my primary sheet is still not showing as a Dynamic content.

 

2017-08-23 08_57_03-Create your flow _ Microsoft Flow.png

 

 

 

Highlighted
Anonymous
Not applicable

Re: Smartsheet - When new row is added

Hello All,

 

I figured out a work around for this and it is to use the expression builder.

 

here is the different expressions that I use:

 

first(triggerBody()?['cells'])?['value'] (first value from the array)
first(skip(triggerBody()?['cells'],1))?['value'] (Second value from the array)
first(skip(triggerBody()?['cells'],2))?['value'] (Third value from the array)

 

And you can just keep building this out as needed depending on how big your array is.

 

 

View solution in original post

Highlighted
New Member

Re: Smartsheet - When new row is added

Fantastic! This works like a charm Smiley Happy

Highlighted
Regular Visitor

Re: Smartsheet - When new row is added

Hi ADGraham, 

 

Thanks so much for your post I've been searching for a way to get dynamics content out of a smartsheet for a while! Would you be able to expand more? Specifically on what goes in ['Value']? I assume ['cell'] is the cell name (eg: [primary column]1) but what's value? 

 

sorry answer is probably obvious...

 

 

Highlighted
Administrator
Administrator

Re: Smartsheet - When new row is added

Hello, @MikeLockwood!

 

Have you had a chance to apply @Anonymous‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

 

Thank you for being an active member of the Flow Community!

 

-Gabriel

Flow Community Manager

-Gabriel
Community Manager
Microsoft Power Automate | Power Virtual Agents
Are YOU a member of a Power Platform User Group?
Fill out This Form to claim your Community User Group Member Badge!
Highlighted
New Member

Re: Smartsheet - When new row is added

Can someone please post an actual working example of using Flow to copy data FROM SmartSheet into either Excel or CSV.

 

The example "Copy data from Smartsheet to Excel" flow template does NOT work at all.

Highlighted
Helper I
Helper I

Re: Smartsheet - When new row is added

I've just come across this after trying time and time again to figure out ways of getting cell data from Smartsheet.

 

The template provided by Flow does nothing, and adds a  "for each" section in which adds in cell data and applies to to "add a row" actions.

 

I'm actually adding this data into Excel but the logic remains the same.

 

I know this post is proper old now, but how did you use the expression builder to do this? You must have some knowledge of WDL to get there? I think the parts I couldn't quite get my head around were referencing 'Value' with "?" marks and then using the Skip function to count from what I guess is an initial index location in the Smartsheet body output?

 

Seems quite tough learning this from scratch!

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,856)