One workaround for the limited number of delegable functions is to pull all database records into a local collection and run your operations against that collection instead of the parent database table.
The biggest hurdle to this approach is the 2000 record limit placed on the “Collect” function used to pull records from the database. There are workarounds for this limit as well, but they’re complicated and inelegant.
Please remove this record limit, or at least provide users with an alternative way to circumvent this limit or, even better, run complex operations against database tables.
JoeF-MSFT
on:
AI Builder - Form Processing