Forum Discussion
read sharePoint folder name and generate hyperlinks on sharepoint excel cells that links to folders
GoallIn
Sure. You could create a Power Automate Flow that reads all Folders from the document library (assuming you have only one) using the "Get Files (properties only)" Action with "Include Nested Items=Yes" and a Filter "ContentType eq 'Folder'"
Then you can store the results in a CSV file and save it on SharePoint (or insert the items into an excel file using the Power Automate Excel Actions)
But the idea with this "Index" Excel File seems wierd... I personally would use the SharePoint search for that usecase.
To do so, i would install the PnP Modern Search Webparts (https://microsoft-search.github.io/pnp-modern-search/), set the query to "ContentType:Folder" and configure the webpart to display the results as a List.
This would surely be more configuration and is a little bit complicated but you would have a SharePoint page with always the current results.
Hi SvenSieverding, I've being playing around with power automate, but I have not succeed at all.
i) in order to make changes I need to insert tables and it's not enabled for excel online with xlsm extension:
besides that, inserting tables might change the excel client format and might turn the overall process to be a semi manual task.
Is there any other tool you have in mind I can check out to write data from excel online to another excel online?
- You might generally have problems if you are using a xlsm file format, because macros are not working in Excel Online.
You could create a new worksheet in your file and add a table there. Then you can populate that table with data from a Power Automate Flow. After that you can use the call Office Scripts Action from Power Automate to call an Office Script
https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel
In that ccript you can copy the values into the cells in your Report
Alternatively you could think about other technolgies like Power BI or a Power App
- Hi Sven! thanks for answer me! My knowledge for power automate is really shallow but I'll definitely give it a try! Thank you again for this valuable insight!
