web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter from a Lookup i...
Power Apps
Unanswered

Filter from a Lookup in DV

(0) ShareShare
ReportReport
Posted on by 119

In 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: 

" Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 208"
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard