Hello - new poster here - I have searched and tried different methods but nothing seems to be working. Any guidance is appreciated.
We are going through a reorganization effort of a large volume of files on an internal server.
I have been successful at using the Get Files in Folder action which saves the list and its related information in variable %Files%.
I would like to output that list into a csv or excel file so we can distribute the list among our department to review the files for deletion, moving etc. In the end, I need a file (csv, excel , text) that has rows of data with the following columns:
FullName, Size, LastAccessed, LastModified, Directory - all of which are standard detail collected in the Get Files from Folder action.
When I write to csv file from %Files% it only gives me the FullName of the file, a comma, then next file name in line so excel thinks its hundred of columns instead of rows which makes it unusable in excel or even notepad. I need to have a separate row for each filename (and its data).
When I tried creating a data table and adding a header row then doing an each loop to insert a row it does not seem to be adding each column (Name, Directory, Size). I get an error that the row being added has fewer columns (1) than the datatable(15).
My loop is taking %DataTable% +[ CurrentItem.FullName, CurrentItem.Size, and so on]%
but it seems to either only be picking one column or combining them all into one column.
Any guidance is appreciated!
