Hope this topic finds you all well,
The team is using sharepoint to store excels that contains data that comes from Revit and another excel online inside an outer folder:
a) the excel online that we wish to read data from
b) the excel file which we wish to write data in:
Have you face anything similar before and is it doable through revit macro? I've being diving into Power Automate but I have encounter many drawbacks
i) In order to use actions that read data from excel online, I have to open the excel file and insert tables at the range that contains my data. This turns to be a semimanual process.
ii) I can not insert tables in excel onlines with .xlsm extension
and the update row action is not reading excel file with the same extension
all the best,
Miguel G.
