Data Shuttle Not Recognizing Excel File Saved Via Power Automate

Question

A colleague has Power Automate set to save Excel files (.xlsx format) to a standard SharePoint location each night. The files have one tab each, are consistently named, and have no extra rows.

Data Shuttle will not recognize the Excel files unless they are manually opened and closed. No change is made—literally just opened and closed.

We shouldn't have to manually intervene. How can the manual intervention be avoided so the Data Shuttle upload runs automatically?

Thanks,

Lori Flanigan

Georgie · Answer

Hi @Lori Flanigan,

I checked in with our Support team who confirmed they have now responded to your ticket. Please continue to work with them regarding this issue.

Thanks,

Georgie

Lori Flanigan · Answer

Thanks, Georgie. I submitted a ticket Monday morning when I saw that I had no responses yet to this post. Still waiting to hear from Smartsheet.

Georgie · Answer

Hi @Lori Flanigan,

This sounds like unexpected behaviour - if you haven’t already, I recommend opening a Support ticket so that the team can investigate this and assist.

Thanks,

Georgie