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...
Sparks729 If you are looking for a place to upload your already generated report, create a document library and upload your report there. You can automate the upload process using Power automate.
If you are looking to create a list in SharePoint and feed off your report data as list items everyday? You can use Power automate for that as well. Trigger the automate to run every day, parse your excel and add each row as an item in your existing SharePoint list. Check this article on how to parse and extract info from excel https://docs.microsoft.com/en-us/azure/cognitive-services/language-service/named-entity-recognition/tutorials/extract-excel-information