Forum Discussion
read sharePoint folder name and generate hyperlinks on sharepoint excel cells that links to folders
Hi everybody, I hope this post finds you all well. Basically, I've different folders inside the sharepoint cloud that has a keyword character like ..._A1, ..._A2, ..._A3, etc. Then to simplify our l...
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
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
