Skip to main content

Notifications

Power Apps - Power Apps Experimental Features
Unanswered

Filter a dataverse table by a lookup column

(0) ShareShare
ReportReport
Posted on by 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"))
  • romerohe Profile Picture
    romerohe 13 on at
    Filter a dataverse table by a lookup column
    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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics