Read data from excel online and place it to another excel online (xlsm extension)

Copper Contributor

Hi folks, 

I'm trying to read data from excel online:



and wish to place it into another excel online with xlsm extension: 


Is this doable? I've tried using power automate but I believe there is a lack of documentation and have some drawbacks as I can not use the update row action as it is not reading excels with xlsm extensions. Besides that, I need to insert tables in excel files in order to read rows and update rows. However, inserting tables in xlsm extensions is unabled :



0 Replies