Microsoft Dynamics 365 | Integration, Dataverse...

Get User-Information out of SID

(0) Share

Report

Posted on by Community Member

I'm using the relatively new fields SystemCreatedBy and SystemModifiedBy, but I do not want to display the ID but the users-name instead - can it be linked directly to the user's table (which would be which?).

Thanks!

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

vishal bagadia_crm 490 on at

Like (0)

Report

Can you please explain your requirement in bit detail.

If you access those fields in Front end. You will see a lookup of the user/team entity with name.

In the backend when you will retrieve these value in coding, you will get this value as EntityReference under which you can get 3 details.. 1. entityName 2. RecordId..3. Name.. based on the 3rd value you can identitfy the name.

If the 3rd value is empty in EntityReference. Then you need to make an extra service call to retrieve the desired data by using the RecordId and entity name.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sorry -I'm simply trying to display the values of these fields (like here) on a page; for the datetime-fields the display-value is fine, for the SystemCreatedBy/SystemModifiedBy (which are SID's) I want to display the corresponding user's full-name (as stored in table user).

For now I have this peace of code:

    procedure GetFullName(userID: Guid): Text

    var

        UserInfo: Record User;

    begin

        if not UserInfo.Get(userID) then

  exit('');

        exit(UserInfo."Full Name");

    end;

That is called by

field("appSystemCreatedBy"; GetFullName(Rec.SystemCreatedBy))

{

   ApplicationArea = All;

}

But there is no value displayed (even on newly created records).

Was this reply helpful? Yes No