cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Add a row from Smartsheet to excel

Hello, 

 

I am workign on a flow that copies rows into an excel spreadsheet. But I can't seem to get any of the dynamic content into the excel sheet i want to transfer the information? Is  this maybe not the flow i use for that?

 

 

Thank you in advance! 

 

Gina smartsheettoexcel.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
faustocapellanj
Memorable Member
Memorable Member

HI @Anonymous 

If I remember well, I was working with a client a while back that wanted to do something similar to this, and he ended up backing out because the Smartsheets connector wasn't giving him the info that he needed because it was all embedded in some HTML. This might be inside the Data Sheet HTML displayed in your Dynamic content.

Another you can try, add an action after your trigger like Get the columns of a sheet and pass the Sheet Id from the sheet in the trigger. That may give you more content you can use to add to your Excel file. Here's the documentation for the Smartsheet connector: https://docs.microsoft.com/en-us/connectors/smartsheet/ 

Please give that a shot and let us know.

Regards,

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

View solution in original post

2 REPLIES 2
faustocapellanj
Memorable Member
Memorable Member

HI @Anonymous 

If I remember well, I was working with a client a while back that wanted to do something similar to this, and he ended up backing out because the Smartsheets connector wasn't giving him the info that he needed because it was all embedded in some HTML. This might be inside the Data Sheet HTML displayed in your Dynamic content.

Another you can try, add an action after your trigger like Get the columns of a sheet and pass the Sheet Id from the sheet in the trigger. That may give you more content you can use to add to your Excel file. Here's the documentation for the Smartsheet connector: https://docs.microsoft.com/en-us/connectors/smartsheet/ 

Please give that a shot and let us know.

Regards,

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!
Anonymous
Not applicable

Thank you this definitely helped!

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,529)