Using Microsoft Flow to update an excel sheet when a Smartsheet is updated
I have been searching and trying out with Microsoft Flow to update an excel sheet in SharePoint, when triggered by "When a sheet is updated - Smartsheet".
However, no matter how I try, I am not able to get the specific row data values. I could only retrieve information of that sheet, for example modified date or name of sheet.
Is there any way I can access the data in the smartsheet using Microsoft flow?
I tried using Power Query to update the excel, however, it seems like sharepoint does not allow external connection to files outside of sharepoint.
Comments
-
Hey Sean -
We faced a similar problem when using Zapier - it required using another app (airtable) to store the individual cell values to then pass further downstream (email in this case).
Hope this helps?
Sean
-
Question : Is there a way to Update a SmartSheet via an excel spread sheet using Power Automate. Power Automate does list a template for Copying data from SmartSheet to Excel via Online Sharepoint BUT nothing in the reverse.
-
Hi, did you ever figure this out? I'm pretty sure you can go from Excel to Smartsheet.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives