SharePoint Batch Macro - Reading in multiple files

Question

Hi all!

I'm looking to bring in multiple files (with different schemas) through the SharePoint Input tool. I set up a batch macro to read in the separate files, however I'm stuck on configuring the SharePoint Input tool that reads into the batch macro. I saw there was feature to "Import only list of file paths" under the Configure File tab, but I do not see that option.

If anyone has any suggestions that would be greatly appreciated. Thanks!

Screenshot (12).png

abacon · Answer

@taylormgruendel Check in the Select File Section, there is a section 'Read Only List of Full Paths' there. I believe the section you are talking about is 'Import only the list of sheet names' which is in the configure file section.

Bacon

Alter_Shivi · Answer

I had the similar requirement couple of days ago and i was able to achieve this. Although its been years, let me know if you are interested in the solution.