Answered

Smartsheet - When new row is added

(0) Share

Report

Posted on by MikeLockwood

197

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

Categories:

Using connectors

I have the same question (0)

All responses (14)

Answers (1)

v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

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

Regards,

Mona

Was this reply helpful? Yes No
MikeLockwood 197 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
mrisch 8 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

All these requirement can be posted to Idea forum here:

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

Regards,

Mona Li

Was this reply helpful? Yes No
mrisch 8 on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
rilu20174218 8 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
rilu20174218 8 on at

Like (0)

Report
Copy link

Link copied!

Fantastic! This works like a charm

Was this reply helpful? Yes No
kateriley on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No