Forum Discussion
Copy and paste/append values along with formatting within workbooks
Hi folks, We have a requirement where all the excel files from a particular document library in SharePoint and all the content in each sheet of each files (Source) need be populated in a specific...
Power query allows you to do this on a per-sheet basis, but it isn't able to also pull in formatting. Which makes me wonder: Why would you want to include formatting?
Thanks for your reply JKPieterse
I have a requirement where user can upload excel files (Could have different sheets and formatting) in a particular document library as a supporting files. After that user can trigger a flow which going to create another main file, Add some data on it with office script, after that below the data, Everything from supporting files should be populated along with formatting.
Hope you understand what I need to achieve.
