Identify User ID in Error message

Objective

There are cases where an error message tells you that a user has no security privilege to do something. But the system does not tell you the name of the affected user, only their GUID (a unique identifier for a record). The GUID is a long number that shows up in your error message.

For example, such an error message could look like this:

In this case, the user with the GUID "5ea6a189-0dee-ec11-bb3d-6045bd954840" is missing a Read ("prvRead") privilege for the table Leave Request (technical name "xrm1_leave Request").

This tutorial shows you how to find out which user this error message means.

Process

System Admin

Open user list in Power Platform Admin Center

System Admin

Download user list to Excel

System Admin

Unhide GUID column

System Admin

Find GUID from error message in the Excel File

Prerequisites

You are System Admin

Click Through

Start in the Power Platform Admin Center
Login with your System Admin credentials
In the left side menu, click on Environments
Open the correct environment
Click on Settings in the top bar (Screenshot)
Under Users + permissions, click on Users (Screenshot)
Click on Manage users in Dynamics 365 (Screenshot)
Set the view to Enabled Users via the drop-down, then click on Export to Excel (Screenshot)
Save the Excel File according to data protection requirements and open the file
Click on Enable Editing
Unhide Column A, as this contains the GUID
- To unhide columns A-C, you need to exactly hit the vertical line on the left side of column D and "drag" it open
Press Ctrl + F on your keyboard simultaneously to open the Search
In the field Find what:, enter the GUID from your error message
Click on Find Next
If the GUID is in that file, it will jump to the GUID of the user we are looking for

Result

In our example, the GUID leads us to the user "HR Employee".

Tips & Tricks

If you were not able to find the GUID from your error message in the list as described above, it may be that the error message refers to a deactivated user.

In this case, try to follow the same tutorial, except you export the view Disabled Users from the Power Platform Admin Center instead of 'Enabled Users'.