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 :
