Display PC user name on Sharepoint list form for new record

Question

I want to display the users name on a sharepoint list when a new record is recorded. I do not want to use power apps for this assignment so I assume JSON is my only choice but I do not know how to write the code for dispalying user name in JSON. Any help is much appreciated!

Tuhin Paul · Answer

To display the user's name in a SharePoint list when a new record is recorded without using Power Apps you can leverage SharePoint Designer workflows or Microsoft Power Automate (formerly known as Flow). In this case you might not need to directly write JSON code but use the platform's workflow capabilities to achieve your goal. Here's a general guide using Microsoft Power Automate: Create a Flow: Navigate to Power Automate (flow.microsoft.com). Click on Create to start a new flow. Trigger: Choose an appropriate trigger based on your scenario (e.g. When an item is created in SharePoint). Add Action: Add an action to get user details. You can use the Get user profile action or any other relevant action based on your requirements. Configure the action to get the user's display name. Update SharePoint Item: Add an action to update the SharePoint list item with the user's display name. Specify the list and item ID to update and set the display name field with the output from the previous action.

Jayraj Chhaya · Answer

To display the PC user's name on a SharePoint list form without using Power Apps you can utilize JavaScript and SharePoint's Client Object Model (CSOM). Here's an example of how you can achieve this: Open the SharePoint list form in SharePoint Designer. Add a Content Editor Web Part to the form. Edit the Content Editor Web Part and insert the following JavaScript code: SP.SOD.executeFunc('sp.js' 'SP.ClientContext' function() { SP.SOD.executeFunc('userprofile' 'SP.UserProfiles.PeopleManager' function() { var context = SP.ClientContext.get_current(); var peopleManager = new SP.UserProfiles.PeopleManager(context); var currentUser = context.get_web().get_currentUser(); context.load(currentUser); context.executeQueryAsync( function() { var userDisplayName = currentUser.get_title(); document.getElementById('userDisplayNameField').innerHTML = userDisplayName; } function(sender args) { console.log(args.get_message()); } ); }); }); In the code above we use the SharePoint Client Object Model to retrieve the current user's display name. The display name is then inserted into an HTML element with the ID 'userDisplayNameField'. Make sure to replace 'userDisplayNameField' with the actual ID of the field where you want to display the user's name.