Get User Details on Login in Model-Driven App

(0) Share

Report

Posted on by naidu1811

109

I am working on a Model-Driven App in Power Apps, and I need to retrieve the following information when a user logs in:

Username
User Email
User Role

Once I retrieve this information, I need to save it into a Dataverse table called Users.

Could anyone guide me on how to achieve this using JavaScript? Specifically, I need help with:

Retrieving the logged-in user's details (username, email, role).
Storing this information into the Users table in Dataverse.

Any code samples or guidance would be greatly appreciated!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Ravindra Jadhav 342 Moderator on at

Like (0)

Report
To retrieve the logged-in user's details (username, email, and role) in a Model-Driven App and save them

Step 1: Retrieve User Information

In a Model-Driven App, you can access the current user’s details using the Xrm API:

// Get the logged-in user ID var userId = Xrm.Utility.getGlobalContext().userSettings.userId; // Get the username and email var userName = Xrm.Utility.getGlobalContext().userSettings.userName; var userEmail = Xrm.Utility.getGlobalContext().userSettings.email; // Fetch user role via Web API (assuming you want to retrieve the user's role name) Xrm.WebApi.retrieveMultipleRecords("systemuserroles", `?$filter=systemuserid eq ${userId}`) .then(function (result) { var userRoles = result.entities.map(role => role.name); // Array of role names saveUserData(userName, userEmail, userRoles); });

Step 2: Save User Data to Dataverse

Now, create a record in the Users table using Xrm.WebApi.createRecord:

function saveUserData(userName, userEmail, userRoles) { var data = { "username": userName, "email": userEmail, "role": userRoles.join(", ") // Concatenate roles into a single string if multiple }; Xrm.WebApi.createRecord("users", data).then( function success(result) { console.log("User record created with ID: " + result.id); }, function error(error) { console.error("Error creating user record: " + error.message); } ); }

Was this reply helpful? Yes No
naidu1811 109 on at

Like (0)

Report

function saveLoggedInUserData() {
// Get the logged-in user settings
var userSettings = Xrm.Utility.getGlobalContext().userSettings;

// Get user ID and username
var userId = userSettings.userId;
var userName = userSettings.userName;
// Retrieve the user's email from the systemuser entity
Xrm.WebApi.retrieveRecord("systemuser", userId, "?$select=internalemailaddress").then(
function success(result) {
// Display the retrieved email and full name
alert("User ID: " + userId + "\nUsername: " + userName + "\nFull Name: " + result.internalemailaddress);

// Perform additional operations here if needed
},
function (error) {
console.log("Error retrieving user data: " + error.message);
// Handle error conditions
}
);
}

Was this reply helpful? Yes No
Suggested answer

Fubar 8,338 Super User 2025 Season 2 on at

Like (0)

Report

Why do you need to capture it and store it in a Dataverse table?

If you want to see if a user logged in you would usually just turn on auditing. https://learn.microsoft.com/en-us/power-platform/admin/manage-dataverse-auditing#startstop-auditing-for-an-environment-and-set-retention-policy and then either check it in the Audit log or Purview.

Was this reply helpful? Yes No