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?
Is it possible to map a checkbox through the DocuSign integration? We have setup a sheet to automatically send and collect W-9 information using the DocuSign integration, including the sync columns feature. However, the Smartsheet does not appear to allow mapping to checkboxes, which are included on the standard W-9 (when…
Why do some users who have been added to the work app have the people with gear icon? What does it represent?
Me and my assistant are the only Smartsheet support for our company. I am trying to utilize Smartsheets for capturing issues as tickets. I have a dedicated email account for tickets. I am using the form for people to request support. But many times they will send email vs submitting the form. Is there a way to…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.