There aren't any templates available but you could build a flow yourself to solve your problem.
Smartsheet connector allows you to insert rows into a sheet.
Here is a video that shows you how to import data from excel to SharePoint.
https://www.youtube.com/watch?v=F2leKcMPAtw
Just replace the SharePoint Create Item action with Smartsheet's Insert Row action
Update SMARTSHEET using Power Automate
Shahara Anderson
✭✭✭
Hello,
I have an updated Excel file, and I would like to transfer new rows of data using Power Automate. I see the ability to go from SMARTSHEET to Excel, is there a way to go from Excel to SMARTSHEET?
Thanks,
Shahara
Best Answers
-
Based on Microsoft's list of automations using Smartsheet (here), no, it doesn't look like there's an integration that flows from Excel to Smartsheet using Power Automate.
You may want to look into Smartsheet's Data Shuttle (see here) to sync content from Excel.
Cheers!
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
-
There aren't any templates available but you could build a flow yourself to solve your problem.
Smartsheet connector allows you to insert rows into a sheet.
Here is a video that shows you how to import data from excel to SharePoint.
https://www.youtube.com/watch?v=F2leKcMPAtw
Just replace the SharePoint Create Item action with Smartsheet's Insert Row action
Answers
-
Based on Microsoft's list of automations using Smartsheet (here), no, it doesn't look like there's an integration that flows from Excel to Smartsheet using Power Automate.
You may want to look into Smartsheet's Data Shuttle (see here) to sync content from Excel.
Cheers!
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
-
There aren't any templates available but you could build a flow yourself to solve your problem.
Smartsheet connector allows you to insert rows into a sheet.
Here is a video that shows you how to import data from excel to SharePoint.
https://www.youtube.com/watch?v=F2leKcMPAtw
Just replace the SharePoint Create Item action with Smartsheet's Insert Row action
-
Thank you @atif_hafeez ! It worked perfectly. Do you know how to get it to update the sheet without duplicating the data?
Thanks,
Shahara
-
I have the same question- did you figure out how to update the sheet without duplicating data? @Shahara Anderson
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- I've set up a archiving workflow using an archive checkbox column in our intake sheet through our blueprint. When this criteria is met, the project is supposed to be moved into an archive workspace, t…
Anyone has a problem Datamesh error code 1302;You cannot edit cells with Column Formula for column(0
Dear Support, I created a Datamesh with lookup value from a Formula column (source column), once run the config, then show error "code: 1302; message: You cannot edit cells with Column Formula for col…- Hi all, I was just informed by our I.T. Dept that Microsoft is killing the Outlook Add-in. We use this add-in quite extensively. Is anyone out there aware of a quick and easy way to attach emails to s…
