I created an Excel Workbook using Desktop Excel. It has x9 Sheets that query x3 different SharePoint Lists and apply conditions and x3 Sheets that query those sheets to append them to produce three separate rosters with different columns.
I'd like to reproduce the same Workbook using Excel Online, store the file in our Team's SharePoint, and use Power Automate to:
1. Refresh All Queries (or the equivalent in Excel Online) on a schedule
2. Export the 3 Sheets as .csv after the refresh so we can pull the rosters and upload them into our service
2a. There is an option to use Power BI to automatically sync those .csv files to our service that I may explore in the future, completely automating the task
However, I've learned that Excel Online does not have Power Query and I'm stumped as to how to accomplish the results I built using Excel Desktop in Excel Online. It has to be Excel based since that is what my current enterprise subscription supports (Excel, SharePoint List, Power Automate are the relevant apps we have access to).
