Pulling multiple files from a SharePoint folder

[ScottHill]

I can find lots of information about pulling in multiple files from a directory but little about using SharePoint. And what I do find doesn't seem to match what I am using. Different parameters and such, possibly version differences with the SharePoint connector. From what I can tell I need to do a batch macro, but it keeps returning with just the first file worth of data. I can't get it to grab the data from the other files in the folder. Is it a dead end to use the SharePoint Connector tool for this?

I admit this is my first attempt at a macro outside of training, but what extremely little information I see online (one example) doesn't match with the parameters I am seeing. And in particular, my version of the SharePoint Connector seems to use an Item ID, which changes with each file, and the "Export list of file paths" doesn't include the item ID, so I don't know how to change this variable in the macro to add additional files.

[ScottHill]

FWIW it pulls in the first file, then I get an error message saying the field schema has changed for the other files. From what I can tell, just looking visually at the worksheets, the columns and field schema are identical.

[Matthew_Pushee · Accepted solution]

The way that I have worked with SharePoint in the past is by syncing the library with OneDrive first.  At the top of the page, there is usually a 'Sync' button that will map the folder to your PC's file system.  Then, you can use the normal Directory and Data Input tools.

Step 1:  Sync with OneDrive

Step 2:  Look for the Library in your PC file system.  For me, this maps to the C:\Users\{username}\ folder.

[ScottHill]

Thanks, that helps!