Data Shuttle Kicked off by Power Automate Flow

Amanda Gilroy

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.

Kelly Moore

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