Data Shuttle Kicked off by Power Automate Flow
I am using a Power Automate Flow to create an .xlsx file and then run an Office Script on it. This is done within 1 flow in Power Automate. The file is saved to One Drive.
Currently I have a Data Shuttle that I run manually to take the updated file and load to Smartsheet.
Is there a way to use Power Automate to run the Data Shuttle after the aforementioned flow is complete? I know that I can schedule the Data Flow, but I'm interested in using Power Automate to run it all at once as I don't always know exactly when the file will be created.
Answers
-
Hey @Amanda Gilroy
If there is a way, I haven't found it yet and I often run Power Automate/Data shuttle sequences. One work-around I use is scheduling DataShuttle to run every hour. If the source file hasn't changed within the hour datashuttle will not make any updates so no harm in scheduling the frequent runs.
Kelly
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 209 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 298 Events
- 33 Webinars
- 7.3K Forum Archives