Power Platform Community Forum Thread Details

Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 208:

ClearCollect(
    transaction_cols, 
    Filter('Leave Application Transactions','Applicant''s Name'.Id = _userID,'Applicant''s Name'.'Display Name' = _userName)
)

I am trying to retrieve records that owned by my personal history for but this error is coming out from no way.

I tested with refreshing cds, delete and re-adding it to my canva app however the issue still persisted. I had confirmed with the object name with and _userName obtained from aad is the same. What else can i do to solve this issue? Is rebuilding a new table with the same name and cols could be a solution to this? Thanks.

Categories:

Connecting to Data