User Profile
SandroBe
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
MS Automate | Identify all SharePoint files and create row in Excel
Hi everyone I am currently working at a flow to identify all documents in a SharePoint Document library and list them in an Excel. After that I would like to filter all files older than 10 years and delete them - but will try this once the following flow works: However, I only get the file saved in this immediate folder and none from subfolders: Plus there is an error in the apply to each (no valid array): My concrete questions: 1) What do I have to amend that files of subfolders are also listed? 2) How can I create a valid array so that for each found file a new row is created within an Excel document? Many thanks for your kind support and taking your time for me. SandroDate format of Document Folder exported into Excel
Hi everyone I am currently trying to download a list (with name & modified) of all files in a Sharepoint Document Folder (including subfolders). As far as I know, I am able to achieve that by doing 'Export to Excel". However, when I open the downloaded Excel, I receive only a 15 digit-figure instead of a readable date format: Is anyone able to help me with this? Thanks a lot for your kind support and best regards Sandro
