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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Not able to compare lo...
Power Apps
Suggested Answer

Not able to compare logged in user with Microsoft entra id column in canvas app

(1) ShareShare
ReportReport
Posted on by 74
Hi All
 
I have Dataverse table with people picker column with lookup of Microsoft Entra iD.
 
In canvas app i need to filter that table with logged in user and with the data of the Microsft entra ID lookup field.
 
I am trying with the filter query which is throwing an error if SQL generic error
 
Filter("MyTable",Entraidcolumn.id=User().EntraIdObjectid) which throws an sql generic error
 
Could you please guide us is there any syntax error or any other query to solve the above issue?
 
Appreciate your help in Advance
 
Many Thanks
SG
 
 
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,433 Super User 2025 Season 2 on at
    Hi,
     
    Can you please share the error and also your code
     
    Also please do this
     
    1. Publish your app (for sure)
    2. If this happens in the Dev environment do the following if not do 2 instead
     
    Option 1
    -Stop playing the app (in dev)
    -Click on the Stethescope (top right)
    -Click Monitor
    -When the Tab opens let it connect
    -Go back to your Dev Studio Tab
    -Run it and cause the error to happen
    -Immediately go to back to Monitor
    -Type Error in the top right (filter for monitor)
    -Look for the group of errors that are about your issue (it will be 2-4)
    -Find the one that provides you with a Flyout (from the right) with 4 Tabs
    You want the Response Tab
    Expand Header and Body
     
    It will tell you whats wrong in much more detail
     
    Option 2 (if you cannot do it in Dev)
    -Go the Apps Page from the home page
    -Click the ... on the line of the app
    -Click Details => Monitor
    -When Monitor Launches click on Play Published Version
    -Go to your app tab you opened and cause the error
    -Immediately go to back to Monitor
    -Type Error in the top right (filter for monitor)
    -Look for the group of errors that are about your issue (it will be 2-4)
    -Find the one that provides you with a Flyout (from the right) with 4 Tabs
    You want the Response Tab
    Expand Header and Body
     
    Please Mark as the Answer and a Like if this helped you.
     
     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard