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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Power Apps Grid Control - Cannot use the lookup column for system users

(1) ShareShare
ReportReport
Posted on by 105

I'm aware this control is currently in preview, but would appreciate if anyone had any tips for how to get around this for now.

I added a lookup field to my sub grid that is currently using the Power Apps Grid Control feature. 

pastedimage1677528627310v1.png

One is a custom lookup field to the 'Users' table called 'Assigned To'. This is supposed to allow the user to add a lookup from the system users table. But when I select the field, nothing happens. No drop down that allows me to select a user (I'm using a functioning view that should show me the users).

I added the 'Owner' column to the view to investigate how lookups to users work. The system user and initials can be selected and removed (like a string) but again, no option to select others users.

Lookups to other tables work fine on the grid.

My theory is, the profile/initials image beside the user name is not agreeing with the PCF and will not allow user selection.

A workaround would be to create a custom table that replicates the user table and use that as a lookup instead, but feels like unnecessary overhead for such a minor issue.

Would anyone know of any other workarounds? A way to display the lookups without the profile image included? Thanks.

I have the same question (0)
  • Suggested answer
    Leah Ju Profile Picture
    Microsoft Employee on at

    Hi AMD99,

    Yes, it seems to be by-design.

    And it is preview feature, it isn't supported by Microsoft Support for production use.

    Microsoft Support is, however, eager to get your feedback on the preview functionality, and might provide best-effort support in certain cases.

    Get Help + Support - Dynamics | Microsoft Docs

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 58 Most Valuable Professional

#2
#ManoVerse Profile Picture

#ManoVerse 42

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 38 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans