Forum Discussion
Create Folders and Import Metadata from Excel Using PowerAutomate
I am looking to see if there is any way to pull data from an Excel Spreadsheet, create folders in a Document Library and fill in the columns. I am a line staff within my organization and the pro...
Sparks729Sparks729What i understood from your question is, you want to create folders in SharePoint with the names given in the excel spreadsheet. This can be achieved simply using VBA Macro. I have recently done this type of thing. Later you can use PowerAutomate (MS flow) to provide the necessary access the user specific folder using Excel. Please let me know, if you need VBA macro and PowerAutomate flow steps to achieve this.