cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MikeLockwood
Level 8

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
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
Community Support Team
Community Support Team

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.
MikeLockwood
Level 8

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.
Community Support Team
Community Support Team

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.
mrisch
Level: Powered On

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

Community Support Team
Community Support Team

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.
mrisch
Level: Powered On

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!

rilu20174218
Level: Power Up

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

 

 

 

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

rilu20174218
Level: Power Up

Re: Smartsheet - When new row is added

Fantastic! This works like a charm Smiley Happy

kate
Level: Powered On

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...

 

 

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
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!
SeanHolm
Level: Power Up

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.

trand86
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,483)