Hi @norashura
In short yes but I wanted to bring to your attention a potential concern related to the data row limit in your applications. If your applications exceed this limit, it may have an adverse impact on the number of records that can be retrieved from your data source into your application.
To mitigate this issue, I would recommend exploring an alternative approach by utilizing Power Automate and implementing a batch processing mechanism to transfer the data into a collection within your application.
Here is my primary advice: As long as the number of records you are collecting remains below the data row limit, you should not encounter any issues.
However, if you anticipate exceeding 2000 records, I strongly advise exploring alternative data gathering methods or revisiting your filtering criteria to eliminate the use of the "in" operator, as this specific part of your code is non-delegable.
To enhance your awareness of this matter in future development, I suggest initially setting the data row limit to 1. This way, if any delegation issues arise, they will become readily apparent as you will observe only one record displaying in your application.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it Thumbs Up.
Thanks
Andrew
