448
Hi all
in a new personalized table, I've a column that is a "search field" for "name" in the User table .... when I select the user from the list, I want to retrieve and fill in the email value in other column (email_user) of my new table.
thanx for any help, suggestion or link with samples
Hi Bipin Kumar
I've tried that way yesterday, but it give me the error... today I've correct the type of field ('email' instead 'string') and all it's working.
Thanks a lot
Hi,
Try using below syntax in calculated field.
Your lookup field.internamemailaddress
You can use data from Lookup records within your Action. You first have to select the Lookup field and then type a period. After that, you can select one of the fields available on the related entity. For example, in the case of <LookupFieldName>.<RelatedFieldName>, you can select: ParentAccountId.AccountNumber
Hi Leah Ju
thank you for all your exposures, but I'm new of D365 and all it's very difficult for me. Can you give me an help for dummies please?
As you can see in picture, in my custom table I've a column (userid) related with systemuser[name] ... I need to retrive the email address of userid from systemuser table
Hi Bipin Kumar
I've read your link, but it's to much difficult, I'm new in D365 ...
Please can you give me some example how to retrive the column "internalemailaddress" of table "systemuser"?
As you can see in picture, in my custom table I've a column (userid) related with systemuser[name] ... I need to retrive the email address of userid from systemuser table
Hi a33ik
this seem usefull but give me an error.
I need to retrieve the "InternalEMailAddress" data of "systemuserid" from the 'systemuser' table and insert it into my custom table where I have selected the user via a search field in relation to systemusertable.
Hi DiePic,
I've a column that is a "search field" for "name" in the User table.
So User and the new personalized table is 1:N relationship, one lookup column related to user table in the new table, right?
You want to show user's email in the new table, many ways can help you display parent(User) information on a child table(new table).
1.Not creating one new field in child table, using quick view form.
2.Creating one new field in child table, How to populate the field with value from parent table automatically?
(1) As Andrew suggested, use calculated field.
(2) Map Parent Fields to the Child:
However, Data Mapping will populate the mapped fields if the child record is created from the parent form, and the big consideration here is that if the value of the field changes on the parent field after the child field was populated, the value will not update on the child (i.e. the value on the child is static).
(3)Workflow/Flow:
(4)Js code:
https://www.adyatantech.com/blogs/how-to-retrieve-attributes-of-an-entity-in-dynamics-365
Hello,
I believe you can use Calculated field for that purpose - www.marksgroup.net/.../
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,263
Super User 2024 Season 2
#2
Martin Dráb
228,112
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (