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?
Hi @Shahara Anderson
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.
@Genevieve P Thank you
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.
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?
Right now we have the Business Plan, but I'm considering moving to the Enterprise Plan only to get access to the Work Apps feature. Looking for some real user reviews to determine if it would be worth it. What do you like and not like about the feature?
I am looking for a way to set up a report in my parent blueprint so that: Every time a new child project is provisioned, a specific sheet from that project is added to the report at the parent level. The parent report is a collection of that sheet in all child projects. Things I tried that didn't work: -Adding the child…
How do you get the URL for the Calendar so that others can view. I tried the Open Sheet, but cannot find the "Web Form" anywhere.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.