Data Shuttle w/ Excel Table

Options

I use powerautomate to take e-mail attachements and update the contents in the file in a sharepoint. It works great except for one source. The contents have the data in a table and the shuttle won't recognize it. What can I do to help the data shuttle recognize my data headers in the excel table?

Tags:

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey @frob

    Without seeing the setup, I can only offer some suggestions of items to check.

    1. Check to make sure your file types match, that is if you told datashuttle it's an .xlsx make sure it's not a .csv
    2. Check what row number the headers are in vs what row number you said the file starts at.
    3. Check your tab number in the file (and check the file doesn't have any hidden sheets)

    When datashuttle is having trouble with my initial setup I often manually upload the file to the sheet. Just once. After that datashuttle often self-corrects any issues it had with the file.

    Did any of these work for you?

    Kelly