Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / How to change value of...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

How to change value of a form field to the user?

(0) ShareShare
ReportReport
Posted on by bp3378 190

I have a form and one of the fields is the requestor.  On form load, I want that field to be populated with user's name.  I have a custom user table that contains the users of the app.  So I prefer to search in this table to get the name.  I understand that this can be done with javascript.  Can someone provide some resources for doing this?  Thanks.

  • bp3378 Profile Picture
    bp3378 190 on at
    RE: How to change value of a form field to the user?

    thanks!

    This should be very helpful i'll take a look.  

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to change value of a form field to the user?

    Hi bp3378,

    Yes, you could use JS to achieve this. Please follow the step:

    1. Create an onload event on your form. Reference: Dynamics CRM JavaScript OnSave and OnLoad - Carl de Souza

    2. Use retrieveMultipleRecords() method to retrieve your custom user table in your JS and then set the user lookup field. 

    Reference:

    https://docs.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/xrm-webapi/retrievemultiplerecords

    Set and Retrieve a Lookup Id and Value using Xrm.WebApi - Carl de Souza

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,885 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans