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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Chain of Command on Form Extension Data Source

(0) ShareShare
ReportReport
Posted on by 670

I have created an extension on the SysUserManagement form by adding an additional checkbox on this page, I would like this value to be saved when the user info page is saved.

2656.png

This new parameter is user specific, so I would like to associate it to a user entry. The current datasource for the form includes the UserInfo table but this does not allow for creating extensions, instead I have used the SysUserInfo table to create a new column via extension of type boolean.

6471.png

And then used this as the datasource for my new custom field on my form extension.

0638.png

At this point, I need to somehow hook into the write method so when a user saves the form my custom value gets written as well.

I've been looking at other examples of Chain of Command and form extensions but am unable to find an example where someone creates an extension for a form, adds a new data source to their extension, and then tries to write to it using Chain of Command.

Is this possible? Is there an easier way to do what I'm trying to accomplish?

Thanks for any help!

I have the same question (0)
  • Suggested answer
    Sukrut Parab Profile Picture
    71,735 Moderator on at

    Hi Alex,

    Your custom check box is in SysuserInfo table , correct ? In that case i dont think  you have to write any code . When you import user , entry gets created in Sysuserinfo Table. When you edit user after importing update method gets called for the same table.  I did exactly same thing you  are trying and that works without any code. See below screenshots.(10.0.7 ,PU 31)

    userform.JPG

    user2.JPG

  • Mea_ Profile Picture
    60,286 on at

    And why do you want to do it on a form level ? Use CoC with insert or update or both on the table itself, this way you will have consistent behavior for all other forms where this table is included. Another option is to subscribe to an event. 

  • alexmeyer.itguy Profile Picture
    670 on at

    Sukrut,

    Thanks for your help!

    You are correct, the field is on the SysUserLog. I recreated your example from above but I cannot seem to get the system to save the data to the correct user.

    3007.png

    For example, I created a enum NoYes field and a string field on this form. Then went to the ALICIA user and updated the values for these, enabling the checkbox and setting the string to '123'.

    5808.png

    But in the database the values are not updating for the correct user.

    7801.png

    And regardless of the user i make the change on, it always updates those same records and never corresponds to the correct user.

    That's what initially led me to believe I had to use chain of command on the form, since it doesn't appear the form is using the user context when selecting the values from the database. To make the form init to load the correct values for these records and then the same thing on the save/commit.

    I am also trying this on a PU31 10.0.7 box.

    Thanks again!

  • Verified answer
    Sergei Minozhenko Profile Picture
    23,095 on at

    Hi Alex

    How you specified "Join Source" on the form extension for your SysUserInfo data source? Looks like it's not linked to UserInfo table.

    BR, Sergei

  • Verified answer
    Sukrut Parab Profile Picture
    71,735 Moderator on at

    HI Alex ,

    I tried it with different user as well and it works properly , so I would be interested in joinSource property of  the new datasource as well. can you please share what you have specified over there.

  • alexmeyer.itguy Profile Picture
    670 on at

    Sergey,

    You were exactly correct, the Join Source was incorrect on my form extension.

    Thanks for your help!

  • alexmeyer.itguy Profile Picture
    670 on at

    Sukrut,

    You are correct, the Join Source was set incorrectly on my form extension. Thanks for all your help!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 658

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 468 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 333 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans