You also cannot create indexes, constraints, or triggers on table variables, except for a primary key or unique index that is declared inline with the table variable definition.

SQL Server procedures can have, at most, 2100 parameters. Server-side logic is required to assemble these individual values into a table variable or a temporary table for processing.

We are excited to announce that SQL Server environment variables (Entra) for Power Apps support is currently rolling out and will be in Preview regions by Jan 22 and in all regions – including ...