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

Announcements

Welcome to the Power Platform Communities
You're Invited to Keeping It Real with the Power Platform
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter a dataverse tab...
Power Apps
Unanswered

Filter a dataverse table by a lookup column

(0) ShareShare
ReportReport
Posted on by romerohe 13
I have an odd error after turning on the new analysis engine.
 
Simply I cannot filter a table on dataverse by a lookup column. The odd situation is that I can do the same by other lookup column from same table (both columns have the same properties).
 
The error I get is (in spanish): Error al intentar recuperar datos de la red: Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 207
 
The expression I'm using is: 
Filter([Table];[LookupColumn].[UniqueRowId]=GUID("xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxx"))
Categories:
Experimental features
I have the same question (0)
  • romerohe Profile Picture
    romerohe 13 on at
    Update: If I make a new app from scratch using the same tables, there is no error and everything goes well. The problem appears when I "transform" my app from the old engine to the new one.
     
    I could restore a version that not use the new engine and it works like a charm, after turning on the new engine it broke again.
     
    Finally, if I turn off the engine after turned on, the app remains broken!

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

News and Announcements

Welcome to the Power Platform Communities
You're Invited to Keeping It Real with the Power Platform

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 762

#2
11manish Profile Picture

11manish 640

#3
Valantis Profile Picture

Valantis 548

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans