cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Output Clause error on calculated column

There needs to be a way to select or disable the output clause, maybe a way to see the SQL that it is sending to the server.

 

My issue is:

I get this error - 

Column 'inserted.[CALCULATED COLUMN]' cannot be referenced in the OUTPUT clause because the column definition contains a subquery or references a function that performs user or system data access. A function is assumed by default to perform data access if it is not schemabound. Consider removing the subquery or function from the column definition or removing the column from the OUTPUT clause.

 

Even though I am not updating that caluclated column.

 

this is recreatable in SQL Server Manager by adding this clause to a standard update query-

OUTPUT inserted.[CALCULATED COLUMN]

 

I'm able to pull data fine. I am able to update fine when there isn't that calculated column... but our tables have columns, some of which are calculated. This application should have the ability to handle those tables too.

Status: New
Comments
New Member

Hi Shegs,

 

I'm running into the same problem.  Any chance you've found a fix?

 

~ NPT

Advocate II
Not that I've heard. I hope they figure it out so I can use this service.
New Member

It looks like building a Flow can be a workaround. I've done that with previous apps I've built.  I might give it a try real quick.

 

~ NPT

Frequent Visitor

Any fixes to this, having same problem?

Regular Visitor

Encountering the same problem. If it isn't possible for PowerApps to use SQL tables whose calculated columns use functions, please could you enable Views to refresh / re-run the query when they are called from PowerApps? I've seen in other discussions that it is necessary to manually refresh any Views that are pulled into PowerApps for the values in these Views to update. Either way, PowerApps needs to be able to access up-to-date calculations derived from the source data. 

Helper II

I've had the same problem trying to Patch a SQL table with two computed fields. The only workaround so far is to not have computed fields in your tables and then the Patch works as you would expect.