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:

GoallIn_0-1665426139442.png

 

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

GoallIn_1-1665426170578.png

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 :

GoallIn_3-1665426352219.png

 

0 Replies