I have an Excel file at On Drive which is loaded by some "oracle query - simple select" and it is updating every time when it is opened.
The data are formatted as table and has no formula.
I can connect it into PowerApps, but after setup and run the app, it creates a new column called "PowerApps" in the excel file and the query stop to work. This way the table will not be updated as I want.
Is there a solution for that? Or there is no support for excel file with data coming from some query?