Error when getting data from SharePoint - error was read from payload

[TrevLc]

Hi,

I am trying to get data from SharePoint (SharePoint folder connector).

I am able to connect and "see" a preview of data (and files to select)

As soon as I apply a step - eg sort by date modified, I get an error

"An error was read from the payload"

I have tried a step to "remove error" rows, but that still does not work.

There is no "error property" for me to see more detail.

I have tried deleting my credentials and re-connecting, but I still get the error.

Edit - if I change SharePoint.Files to SharePoint.Contents at the start, it seems to work, but I would still like some help, as SharePoint.Files should still work

Please help

[Anonymous]

Hi @TrevLc 

You mentioned that "if I change SharePoint.Files to SharePoint.Contents at the start, it seems to work" , can you expalin it in detail ?  Did you check the data type of column date modified ? 

Best Regards,
Community Support Team _ Ailsa Tao
                                                                    

[TrevLc]

Hi @Anonymous 

If I use this code: it fails with an error on the filtered rows step

let
Source = SharePoint.Files("http://sharepoint/XXSites/XXXX/", [ApiVersion = 14]),
#"Filtered RowsSP" = Table.SelectRows(Source, each ([Folder Path] = "http://sharepoint/XXSites/XXXX/"))

....

If I use this code, it works

let
Source = SharePoint.Contents("http://sharepoint/XXSites/XXXX/", [ApiVersion = 14]),
#"Filtered Rows3" = Table.SelectRows(Source, each ([Folder Path] = "http://sharepoint/XXSites/XXXX/")),
ReportingData = #"Filtered Rows3"{[Name="ReportingData"]}[Content]

in 

ReportingData