I have created a transposed HTML table in power automate that looks like the following table:
My problem is trying to create an excel table in power automate to populate the above data given that the number of the date columns, “2024-07”, “2024-08”, “2024-09”, etc change over time. So in December-2024 a new column, “2024-12” would be added and that require changing the table in power automate flow. My attempt so far in creating this table in power automate is as follows:
I was told it can be done dynamically by office scripts or Graph API calls but I have no idea how to do it in power automate. I appreciate your help