Read Sharepoint files individually

Question

Hello all,

I am attempting to read files from a directory in sharepoint, perform a transformation on the files separately with Python, and then output them in all separate files.  I get the desired output when one file is selected but when I select the directory it attempts to combine them based on the number of columns (they do not share similar structures and I want them to remain separate anyways).  Thank you in advance.

ChBurger · Answer

The issue with your macro is the checked setting at the bottom, which states "Replace a specific string". This will only replace the string specified. What you need to do to configure this properly is to remove that checkbox and send the entire file path if you are attempting to utilize a macro. Otherwise the only time the filename will be replaced is for that specific string. I hope this helps!!!

Cheers,

Chad

mzrickers · Answer

I selected one of the files in the directory and connected a macro to it.  However when I run a macro it only runs the first file and doesn't change to the next files.  Any tweaks I can make?

mzrickers · Answer

Thanks for the quick reply.  I added the workflow.  I am using the sharepoint input tool.  Tried some batch macros but still not the greatest with them yet.  Some examples would help a lot.  Thanks.