I have a scenario where I am first watching a OneDrive folder for a weekly Excel report to be added to it. When a new Excel report is detected, it is put through an HTTP get a file module to grab the file data.
Next, I want an Excel module to grab a specific table within the Excel report and store it as a variable to be added to another already existing Excel file. However, my Excel module is unable to recognise the Excel report file that was grabbed from the HTTP module.
Any idea what the issue could be? I need a worksheet ID, but I cannot find one from the HTTP response.