I don’t know whether this is a dumb question to ask but I am currently trying to build a PowerApp connecting to a large SQL on-prem database with more than 300,000 rows. Since you can’t use a SQL query with on-prem databases, I went with the power query option in flow to generate JSON from my SQL server. The result is pushed back to PowerApps using the response element.
Since I want to filter the output for a datepicker input from PowerApps, I embedded a filter array element in Power Automate.
This all works fine but it takes longer than just a normal SQL query (about 5-10 secs).
Is there a way to load the SQL data in a first flow when the app starts and trigger the filter array when there is an input provided in the datepicker? I have read about nested flows but I am not sure about the trigger in this case.
I hope you guys get what I am trying to do. I first want to load data in a first flow and then filter the resulting array OnSelect of the button.