Run the commands from a command prompt in the topmost folder. If this option is checked, not only items (files and folders) selected are listed, but also items from their sub folders in all levels. You could use this information to populate the CSV file. Two options depending on what you are looking for. (Currently its showing all empty folders) Public oldNR As Long Sub HyperlinkDirectory () Dim fPath As String Dim fType As String Dim fname As String Dim NR As Long Dim AddLinks As Boolean Select folder With Application.FileDialog (msoFileDialogFolderPicker). The output from the Select action should be an array that looks something like the JSON you see below. And I want message-box option (Yes/no) for empty folders. I also need the file size and the last access date in the same line, separated by a special character. (recursively) Each file must be in a single line. You can then use a Select action to extract the information you want from the response from the Send an HTTP request to SharePoint action.įrom: body('Send_an_HTTP_request_to_SharePoint') I need a simple way to create a list of all files in a certain folder. The FSObjType eq 1 filter tell SharePoint you only want folders. The FileDirRef field in the select is the server relative URL for the folder. You can use the Send an HTTP request to SharePoint action to get all the folders in a list or library. Windows 10 Instructions In Windows Explorer go to the location of the folder which you want to print a contents list. Replace with the name of your list or library. Add a comment 1 Answer Sorted by: 0 This may not be exactly what you're looking for, but it might be enough to point you in the right direction. Uri: _api/Web/Lists/GetByTitle('')/Items?$select=*,FileDirRef&$filter=FSObjType eq 1 You can use the Send an HTTP request to SharePoint action to get all the folders in a list or library. I have full permissions on the root drive and inherency is turned on so there should be no folder permission errors. I know it will take a long time but that is okay with me. This may not be exactly what you're looking for, but it might be enough to point you in the right direction. I am wanting to start at the top level, root folder and encompass everything that falls under it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |