New to PowerApps.
Background is working with SQL databases, MS Access databases, Tableau, Power bi, Python etc...for the most part where there is not much of a row limit or limited to what you can do when creating a query or connecting to multiple data sources, etc...
My department is looking into PowerApps vs other tools due to 'everywhere' accessibility, cloud storage(security) and ease of use so I've been looking into it and played around with it quite a bit lately.
My main question is around functionality and delegation:
If I have a table with about 10000 rows or a combination of tables with about 10000 rows from multiple data sources (Dataverse/SQL database/Azure, etc...) or multiple tables or MS/Sharepoint lists and maybe want to relate them and do something cool and functional in PowerApps, etc...Am I limited to query a certain way or have to do things only a certain way in the App because I have to use delegation friendly formulas/functions so it takes into account all the data?
Example:
I want to create the capability of real time searching throughout the entire dataset with a search box or multiple search boxes with the "left", "FirstN", "isblank" and "| |" functions. If the user starts typing in the search box, the results start coming up in the gallery control in real time. Even though only the top 100 results will show up initially when the app loads, the user will be able to query for specific results on the fly from the entire dataset.
In the above example I'm getting the delegation warnings, no results above 500 rows show up and it's frustrating. I understand there are workarounds by using delegation friendly functions, and 'Collections' but...it seems like I'm being "limited" or even "punished" for trying to be creative or give the app more powerful and/or creative functionalities.
Again, new to PowerApps so I want to give the tool a chance, but I also don't want to feel "limited" by what I can do in the App.
