Forum Discussion

lizrowden's avatar
lizrowden
Helper I
6 years ago
Solved

Sharepoint Online Excel Problem Loading data

I am attempting to get data from one of several Excel files that exists in a sharepoint online directory such as the following: https://xxxxxxxx.sharepoint.com/sites/BookSales

When I attempt to load the data I get errors in the query. At first I thought the problem was related to whatever it is trying to do to in the combine & load, but I removed all files except for the single excel file I need and still get the following error:

Expression.Error: The type of the value does not match the type of the column.

The errors appears to be in the 'Date Accessed' column and I have no idea where that is coming from. I've tried to change the data type on the column, but I still cannot get my data to load. Any help would be greatly appreciated

  • Hi lizrowden ,

     

    Please follow the steps bellow:

     

    1. Please use "SharePoint Folder" connector to connect to your sharepoint excel.

     

    2. Click "Transform Data" option.

     

    3. Filter the excel file you want.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Icey's avatar
    Icey
    Community Support

    Hi lizrowden ,

     

    Please follow the steps bellow:

     

    1. Please use "SharePoint Folder" connector to connect to your sharepoint excel.

     

    2. Click "Transform Data" option.

     

    3. Filter the excel file you want.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.