Update SMARTSHEET using Power Automate

Shahara Anderson · 06/16/21

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

Genevieve P. · 06/17/21

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.

Cheers!

Genevieve

Shahara Anderson · 06/17/21

@Genevieve P Thank you

Best,

Shahara

atif_hafeez · 03/11/22

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

Genevieve P. · 06/17/21

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.

Cheers!

Genevieve

Shahara Anderson · 06/17/21

@Genevieve P Thank you

Best,

Shahara

atif_hafeez · 03/11/22

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

Shahara Anderson · 04/22/22

https://community.smartsheet.com/discussion/comment/322286#Comment_322286

Thank you @atif_hafeez ! It worked perfectly. Do you know how to get it to update the sheet without duplicating the data?

Thanks,

Shahara

LaurenLong · 04/23/24

I have the same question- did you figure out how to update the sheet without duplicating data? @Shahara Anderson

Update SMARTSHEET using Power Automate

Best Answers

Answers

Categories