Share
Report
119In a Canvas App, I'm trying to filter a Dataverse table with a Lookup field. The lookup field in the DV table is looking to a Virtual table if that makes any difference. I've done this thousands of times with straight SQL tables, but for some reason this is throwing an error every time I try to use the lookup field in the filter.
Filter('Alert Audits','Alert Type'.Name=gal_Alerts.Selected.AlertyType,Patient.pa_id=ThisItem.pa_id)
'Alert Audits' is a DV table
Patient is a Lookup field that lookups up to a VE connected to a SQL table
The error comes when I add the Patient.pa_ID (Patient is the lookup field). If I remove the Patient.pa_id=Thisitem.pa_id, filtering works and no error.
Error is "error when trying to retrieve data from the network"
Monitoring shows a generic SQL error:
All responses (
Answers (
